Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 22233 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
How global temporary tables are represented and its scope?
Explain external key management in sql server 2008
Define left outer join in sql server joins?
What is mapping schema?
Explain what is public role in sql server?
What is policy management?
How to delete all rows with truncate table statement in ms sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Can we write a distributed query and get some data which is located on other server and oracle database?
Tell me what is a linked server?
What’s the use of custom fields in report?
what's the difference between delete table and truncate table commands? : Sql server database administration
Does table partitioning improve performance?
What is the library index called?
What is nonclustered index with included columns ?
