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

How to execute stored procedures?

1059


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1017


Which are the db2 tools to protect integrity of the database?

1070


What is cobol db2?

930


What are the uses of db2 optimizer?

1221


What is the role of the data page in the db2 database?

971


What is difference between isnull and coalesce?

1005


What is the meaning concurrency in the db2 database?

1053


What are concurrency issues?

1027


What are the prerogatives?

1013


How do I add a column to an existing table in db2?

976


What is reorg?

1069


Which component is responsible for db2 startup and shutdown?

979


What is cloudant database?

1025


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3517