Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38390 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 the database you used in your final year project?
What is set nocount on?
What should be the fill factor for indexes created on tables? : sql server database administration
What are the different editions available in sql server 2000?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is a view and what are its advantages?
Do you know how to implement service broker?
Is sql server 2016 free?
What is the difference between TRUNCATE and DROP?
Differentiate between sql temp table vs table variable?
Difference between LEN() and DATALENGTH() in sql server ?
How to write a query with a right outer join in ms sql server?
What is partition index in sql server?
Explain about system database?
Do you know what is replace and stuff function in sql server?
