what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 10330 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 meant by dclgen?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Is db2 relational database?
What does db2 blu stand for?
When reorg is used?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the use of value function?
What is the maximum size of varchar data type in db2?
List out the data types available.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How can you find out the # of rows updated after an update statement?
What are iseries servers?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What do you mean by commit and rollback?
