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

Answer Posted / siri

Drop : Drop table command it will remove table structure of the data base.....we can't rollback...
SYNTAX :- DROP TABLE TABLE-NAME..

DELETE : Delete table command it will delete rows from the table...for example i want delete empname in employee table i will write the query is.....
SYNTAX :- DELETE EMPNAME FROM EMPLOYEE

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between db2 and oracle?

1068

Is db2 relational database?

915

What are concurrency issues?

1029

What is the max length of sqlca?

1157

How will you return the number of records in table?

880

What is bind plan?

979

Can we insert update delete in view?

908

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

1018

Which component is used to execute the sql statements?

1053

What is a storage group (stogroup)?

1189

What is meant by explain?

1062

List out the three types of page locks that can be held.

1091

How many types of page locks can be held in db2?

994

What are the different types of base tables?

1027

How to resolve deadlock issue

19864