what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 10321 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
how 2 resolve the -311 sqlcode
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
How to select the duplicate rows from a table?
select distinct(empid),distinct(dept),name from EMP will the above query work?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is db2 stogroup?
What is meant by concurrency?
What is a result table?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What does the CHECK Utility do ?
Mention the location where the output received from explain statement is stored.
How do I add a column in db2?
COBOL 
