Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11396 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 |
What is the use of DELGEN in DB2? Can we Write the program with out using it?
Explain the benefits you can get from mainframe connect?
What is a bind card?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is the size of a data page?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is runstats and reorg in db2?
how to resolve -805 . how to see dbrm and package not found
When will you chose to run RUNSTATS?
What is PRIME TABLE and what are the uses of it
How to restart a DB2 program?
COBOL 
