Interested to Buy Any Domain ? << Click Here >> for more details...
what is differnece between DROP TABLE & DELETE TABLE .
- 4 Answers
- 11638 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 package in db2 mainframe?
What is check constraint. Explain with example.
Discuss about db2 bind?
Explain the contents that are a part of dclgen.
What is the use of predicate?
What is the use of value function?
What is the purpose of rollback and commit?
What is the default page size of buffer pools?
What are foreign keys in db2?
Which isolation level provides maximum concurrency?
Mention the location where the output received from explain statement is stored.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do we specify index to include or not during bind process.
What is with ur in db2?
What is drop table?
