what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 10375 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
Where can you declare a cursor in a cobol-db2 program?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is a dbrm in db2?
What is the use of db2 optimizer?
What is concurrency?
List some fields from sqlca?
What is syscat in db2?
What is null value in db2?
what is utility for parm lib
How many types of page locks can be held in db2?
How do I create a view in db2?
Describe major components of db2?
Explain correlated sub-queries.
How would the varchar column remarks defined?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
