Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

what is differnece between DROP TABLE & DELETE TABLE .

Question Posted / durga prasad

Answer Posted / durga prasad

drop table deletes the entire structure from the database
and it also removes entry from syscat.tables. but where as
delete table only deletes the rows in the table.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's The Percentage Free Space ?

1224

How to create backup table in db2?

1089

What is buffer pool?

1099

is it compulsory commitment control in journal?

2474

Are views updateable?

1151

What are the uses of db2 optimizer?

1294

What is null indicator in db2?

1108

Can we delete records from view?

966

Which command is used to connect to a database in DB2 ? Give the Syntax.

1102

define clustering index.

1024

what is the responsibility of the construction superintendent

2140

Explain package in db2 and its advantages?

1212

What is cobol db2?

996

What is dclgen in db2?

1143

What is the cobol picture clause of the db2 data types date, time, timestamp?

1061