Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37036 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
Explain logical operators in sql server?
How to create a dynamic cursor with the dynamic option?
What are different types of views?
Name 3 ways to get an accurate count of the number of records in a table?
What is the definition for sql server 2000?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is coalesce in sql server?
explain different types of cursors? : Sql server database administration
Explain about sql server login?
what is blocking? : Sql server database administration
what is a transaction and what are acid properties? : Sql server database administration
Can we deploy SSRS reports on our personal website?
What will be query used to get the list of triggers in a database?
What are the properties and different types of sub-queries?
What are different backups available in sql server?
