what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 10395 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Name the lockable units in DB2?
What is dclgen in db2?
What are union and union all?
When the like statement is used?
What is the result of open cursor statement?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is host variable?
What is phantom read in db2?
What are the two types of logging in the db2 database? Explain them.
What do you mean by rollback?
What os does db2 run on?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How can deadlocks be resolved?
What is performance tuning db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
