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
Describe major components of db2?
How to test SQL -911 error while developing COB-DB2 program
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to rename a table in DB2 ?
What is innodb buffer pool?
Why cursor is used in db2?
What is bind package and plan in db2?
What db2 400?
What is coalesce in db2?
Are views updateable?
How to take backup of table in db2?
What is declare cursor?
What is the syntax for creating a table in the db2 database?
What is load replace in db2?