what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 9761 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 are the full forms of spufi and dclgen and why are they used?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How do I add a column to an existing table in db2?
What is difference between isnull and coalesce?
What is multi row fetch in db2?
What is consistency token in db2?
What is the maximum size of a char data type in db2?
What is the use of value function?
How can we read records for specific member in CL? AND rpg?
How to run db2 command in windows?
Which component is responsible for processing sql statements and selecting access paths?
Why db2 is called db2?
List out the three types of page locks that can be held.
What is package in cobol db2?
