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 / santy

DROP TABLe deletes the entire Structure of the TABLE from
the database with all the datas it contain, DELETE TABLE
deletes only the rows of the TABLE.

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe major components of db2?

1040


How to test SQL -911 error while developing COB-DB2 program

7441


ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2006


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1053


How to rename a table in DB2 ?

1029


What is innodb buffer pool?

977


Why cursor is used in db2?

984


What is bind package and plan in db2?

1004


What db2 400?

1102


What is coalesce in db2?

1054


Are views updateable?

1070


How to take backup of table in db2?

1020


What is declare cursor?

1042


What is the syntax for creating a table in the db2 database?

1057


What is load replace in db2?

935