What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
Answer Posted / ranjay
Truncate / When use Truncate after that insert new record
into the table row started from 1 but
Delete / When delete record in a table after that insert
new record row id started from after the deleted row
For e g, I m create a table Employee and insert 5 record
row number set identity true and increment by 1
After that, I m delete last record I e row number is 5
after delete I m insert new record in a table then row id
started from 6 not 5 but when truncate table row id start
from 1
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are the new features introduced in sql server 2000? : Sql server database administration
What is lock escalation and what is its purpose?
What is difference between standardization and normalization?
What are the different ways you can create databases in sql server?
Why do we use non clustered index?
What structure can you implement for the database to speed up table reads?
Explain transaction isolation levels in sql server?
What do you need to connect php to sql server?
What are rows and columns?
What is logon trigger?
What gets stored inside msdb database?
Equi join and non equi join is possible with sql server?
Define right outer join in sql server joins?
What is the meaning of sql server?
What is a system database and what is a user database?