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
What is the use of db2?
Comment whether the cursor is closed during commit or not.
Define buffer pool.
Define db2.
Is it possible using max on a char column?
What db2 400?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the information associated with sysibm.syslinks table?
B37 abend during spufi?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Give a brief description of db2 isolation levels?
What is db2 optimizer?
What is cursor with hold option in db2?
is it compulsory commitment control in journal?
What is package in cobol db2?