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...

what is differnece between DROP TABLE & DELETE TABLE .

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 is the use of db2?

1034


Comment whether the cursor is closed during commit or not.

1080


Define buffer pool.

1032


Define db2.

1096


Is it possible using max on a char column?

1122


What db2 400?

1144


Can you tell me how can you find out the # of rows updated after an update statement?

1080


What is the information associated with sysibm.syslinks table?

1106


B37 abend during spufi?

1442


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1051


Give a brief description of db2 isolation levels?

1047


What is db2 optimizer?

1215


What is cursor with hold option in db2?

1052


is it compulsory commitment control in journal?

2460


What is package in cobol db2?

1104