What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 16455 Views
- I also Faced
- E-Mail Answers
Answer Posted / satya
1.Both Truncate and Delete are rollbacked in TSQL.
2.Truncate maintains single record in Transaction log
entire records where Delete writes one-to-one record which
is slow in performance.
3.Truncate reinitializes the IDENTITY count to zero.
4.Truncate gives error with Table Variables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is it possible in sql table to have more than one foreign key?
Explain temporary table vs table variable by using cursor alternative?
Give the query of getting last two records from the table in SQL SERVER?
How to delete duplicate rows from table except one?
Can you get second highest salary from the table?
What is collation sensitivity? Explain different types.
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What are the different types of Indexes available in SQL Server?
What command do we use to rename a db, a table and a column?
Explain triggers in sql?
What do you understand by the data quality services in sql server?
What do you mean by acid?
Can a unique index be created on a column, which contains null?
What are different type of Collation Sensitivity?
What is database replication? What are the different types of replication you can set up in sql server?
