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
How to execute stored procedures?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Which are the db2 tools to protect integrity of the database?
What is cobol db2?
What are the uses of db2 optimizer?
What is the role of the data page in the db2 database?
What is difference between isnull and coalesce?
What is the meaning concurrency in the db2 database?
What are concurrency issues?
What are the prerogatives?
How do I add a column to an existing table in db2?
What is reorg?
Which component is responsible for db2 startup and shutdown?
What is cloudant database?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?