what is differnece between DROP TABLE & DELETE TABLE .
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
Answer / santy
DROP TABLe deletes the entire Structure of the TABLE from
the database with all the datas it contain, DELETE TABLE
deletes only the rows of the TABLE.
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / siri
Drop : Drop table command it will remove table structure of the data base.....we can't rollback...
SYNTAX :- DROP TABLE TABLE-NAME..
DELETE : Delete table command it will delete rows from the table...for example i want delete empname in employee table i will write the query is.....
SYNTAX :- DELETE EMPNAME FROM EMPLOYEE
Is This Answer Correct ? | 1 Yes | 0 No |
What does DSNDB07 database do?
What is a db2 package?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
what is plan? is plan executable or package?
Define declaration generator (dclgen).
What r the comman abends in db2, jcl and cobol???????
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
what is diffrence b/w file-aid tool and file-aid utility???
Explain what a plan is?
What is ibm db2 client?
Explain the function done by data manager?
How do you filter out the rows retrieved from a Db2 table ?