Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11399 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
How do I import a csv file into db2?
What is the use of db2 optimizer?
what is the sqlcode -501
Is it possible using max on a char column?
What are catalog tables in db2?
Mention the different locking levels that are available in db2.
Are views updateable?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Which command is used to connect to a database in DB2 ? Give the Syntax.
Explain the function of data manager.
What is rebind in db2?
What is buffer pool?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
