Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11453 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / samir kumar sahoo.
in DROP TABLE command it will remove the table containts as
well as table structure from the database catalog, also it
release all the storage space it has acquired previously.
we can't rollback it as it is a ddl command.
but in case of DELETE TABLE command it just delete all the
records but not relaese the spaces it acquires .it can be
rollback as it is a dml command.
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
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 ?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the maximum size of a char data type in db2?
What are packages in db2?
What is db2 instance?
What is rebind in db2?
What is the latest version of ibm db2?
Can you use max on a char column?
What is cursor in dbms?
can all users have the privilage to use the sql statement select * (dml)?
What is explain plan in db2?
What happens in bind step in a db2 program?
What is data manager?
Which components manage deadlocks in db2?
How would you find out the total number of rows in a db2 table?
