Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11475 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / siri
Drop : Drop table command it will remove table structure of the data base.....we can't rollback...
SYNTAX :- DROP TABLE TABLE-NAME..
DELETE : Delete table command it will delete rows from the table...for example i want delete empname in employee table i will write the query is.....
SYNTAX :- DELETE EMPNAME FROM EMPLOYEE
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is dclgen in db2?
Is it possible using max on a char column?
What is runstats and reorg in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is cloudant database?
what is the role of the cursor in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is declare cursor?
How can record locking be achieved in those DB2 versions which do not support it?
How to check table size in db2 sap?
What is package in cobol db2?
What is table space in db2?
Define data page.
What is the syntax for FETCH in DB2 ?
Mention the downsides of page level lock.
