What is the difference between Drop and Truncate
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 is difference between count (*) and count column?
Can sub report data source be different from that of the parent report?
What is mssql?
How to execute a stored procedure in ms sql server?
What is the use of tempdb? What values does it hold?
What is the purpose of the master database?
explain different types of backups avaialabe in sql server? : Sql server database administration
Is BCNF better than 2NF & 3NF? Why?
Explain intellisense for query editing
According to you what goes into making the best database administrator? : sql server database administration
how many clustered indexes can be created on a table? : Sql server database administration
How to change a login name in ms sql server?
What is change tracking in sql server?
Define Wed Edition in SQL Azure?
What is the current limitation of the size of SQL Azure DB?