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
Tell me the phases a transaction has to undergo?
What is policy management?
What is the cartesian product of table?
Define self join?
Do you know hot add cpu in sql server 2008?
Do you know exporting and importing utility?
Which sql server table is used to hold the stored procedure scripts?
How can you start sql server in different modes?
What is 2nf example?
What are information schema views?
Explain temporary table vs table variable by using cursor alternative?
What is statement level trigger?
Explain in details security in SQL azure?
What is the difference RDBMS and Graph Database?
What is the datatype of rowid?