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 connect to db2 database from windows command line?
What is multi row fetch in db2?
is it compulsory commitment control in journal?
What is ibm db2 used for?
List down the data types in the db2 database.
If I have a view which is a join of two or more tables, can this view be updateable?
What is db2 bind process?
What is the maximum No of rows per page?
i want to maintain uniqueness on pdf without make lf??????????
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What are the uses of db2 optimizer?
What is package in cobol db2?
What is the use of dclgen in db2?
Explain the contention situations caused by locks?
What are host variables in db2?