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 do I import a csv file into db2?
How do you stop a db2 database in linux?
What is a db2 package?
What is db2 and what is the use of db2 optimizer?
What are the two types of logging in the db2 database? Explain them.
What are union and union all?
How to find schema of a table in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is database reorganization?
What is bind and rebind in db2?
what is a corelated subquerry?
What are the bind parameters ibm db2?
What is db2 bind process?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?