Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11398 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 is ibm db2 client?
What is a db2 collection?
What is package in cobol db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
what is the responsibility of the construction superintendent
What is dbrm? What it contains? When it will be created?
What is check constraint. Explain with example.
What is the syntax for seeing the columns and data types of a table in the db2 database?
How can the duplicate values be eliminated from db2 select?
Give the name of some fields form sqlca.
is it compulsory commitment control in journal?
What is load replace in db2?
What are union and union all?
How do I change the column size in db2?
What is the purpose of rollback and commit?
