Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11208 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
What are bind parameters in db2?
How is the value function used?
What is view db2?
What happens in bind step in a db2 program?
What is db2 catalog database?
What are the full forms of spufi and dclgen and why are they used?
Explain what are the various isolation levels possible?
How does coalesce work?
What is database reorganization?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
is it compulsory commitment control in journal?
What does db2 plan contain?
How do I import data from excel to db2?
What is the reason behind not using select * in embedded sql programs?
If I have a view which is a join of two or more tables, can this view be updateable?
