what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 10350 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 difference between isnull and coalesce?
How do I import data from excel to db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the physical storage length of date data type?
What is db2 and what is the use of db2 optimizer?
Is ibm db2 open source?
What is the difference between using bind () and rebind () methods of naming class?
What is the difference between db2 and oracle?
What is a db2 schema?
How many databases can be created inside an instance in db2 ?
What are bind parameters in db2?
What is ibm db2 database?
How do I delete a table in db2?
B37 abend during spufi?
Can you use max on a char column?
