Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11487 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is explain in db2?
Explain package in db2 and its advantages?
Explain about open switch business continuity software?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is cloudant database?
List out the buffer pools in db2
What is concurrency?
Mention the location where the output received from explain statement is stored.
What is database alias db2?
What is the function of logging in the db2 database?
What is difference between rollback and commit?
Explain the benefits you can get from mainframe connect?
Is the primary key a clustered index?
What is a db2 table?
What is the role of union all and union
