Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11462 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?
What is the max length of sqlca?
Explain the contents that are a part of dclgen.
What is cursor stability in db2?
What is bind in db2?
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 .....
Define declaration generator (dclgen).
What is db2 bind?
What is the maximum number of columns in a db2 table?
Can there be more than one cursor open for any program?
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?
What do you mean by storage group (stogroup)?
What is the difference between cursor stability and repeatable read isolation levels?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How connect db2 database to datastage?
