Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19359 Views
- I also Faced
- E-Mail Answers
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 different types of locks in the database?
Tell about MOM Tool(Microsoft Operator Manager)?
Do you know what are the ways available in sql server to execute sql statements?
What is data mart? : sql server analysis services, ssas
how would you troubleshoot blocking? : Sql server database administration
Where to find ntwdblib.dll version 2000.80.194.0?
How can we migrate from SQL server to SQL Azure?
What is default constraint?
What is default port number for sql server 2000?
What is 1nf 2nf and 3nf?
What is create statement?
What are the different methods available under sqlcommand class to access the data?
What are the two authentication modes in sql server?
Explain the xml support sql server extends?
Can you force a query to use a specific index?
