Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 25195 Views
- I also Faced
- E-Mail Answers
Answer Posted / amita
Delete command only delete the rows from the table but the
schema of the table yet remains.Whereas Truncate command
delete the rows along with the tale's schema from the
memory permanently.
| Is This Answer Correct ? | 3 Yes | 28 No |
Post New Answer View All Answers
Explain what are the basic functions for master, msdb, model, tempdb databases?
What are “phantom rows”?
How to convert numeric expression data types by assignment operations?
What are triggers? How do you invoke a trigger on demand?
can we have a nested transaction? : Sql server database administration
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
How to install sql server 2005 express edition?
Which autogrowth database setting is good?
what are the different stages of Report Processing?
How do you Implement SSIS Packages in your Project?
How to find index size for each index on table?
How to stop log file growing too big?
What is the difference between delete and truncate statements?
What is blocking and how would you troubleshoot it? : sql server database administration
What is onf in normalization form?
