What is the difference between Drop and Truncate
- 20 Answers
- 34060 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / vishant kakwani
drop is delete the data with table and if id is used as autoincrement then id can't be started with 1.
Truncate is delete the only data table as it is and autoincrement id will started with 1 every time if you truncate the table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What does this statement do @@rowcount?
Explain what is raid and what are different types of raid levels?
What is service broker?
Do you know what are various aggregate functions that are available?
What is the recursive stored procedure in sql server?
Tell me what are cursors and when they are useful?
How to read data in a table with "select" statements?
How can a database be repaired?
define and explain the differences between clustered and non-clustered indexes.
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
Explain different types of index?
what are the new features in SSRS?
What is difference between clustered and non clustered index?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is index in an assignment?
