what is differnece between DROP TABLE & DELETE TABLE .
Answer Posted / 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 |
Post New Answer View All Answers
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What does runstats do in db2?
How to fetch the last row from the table in SQL (db2)?
What are types of indexes?
What is the difference between spufi and qmf?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How is the value function used?
what are bind concepts in db2 cobol?
How to execute stored procedures?
Define db2.
What is the meaning concurrency in the db2 database?
How can you quickly find out the # of rows updated after an update statement?
What is the use of value function?
Which component is used to execute the sql statements?
Why cursor is used in db2?