What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 16458 Views
- I also Faced
- E-Mail Answers
Answer Posted / baijnath tiwari
TRUNCATE is a DDL command whereas DELETE is a DML command.
Hence DELETE operation can be rolled back, but TRUNCATE
operation cannot be rolled back. WHERE clause can be used
with DELETE and not with TRUNCATE.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to insert and update data into a table with "insert" and "update" statements?
Describe how to use the linked server?
What is log shipping?
What is database isolation in sql server? : sql server database administration
How many columns can exist together per table?
Explain the xml support sql server extends?
How to restore performance issues and how to check?
How to find tables without indexes?
How to convert a numeric expression from one data type to another?
What is change data capture (cdc) in sql server 2008?
Can we use having clause without group by?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
which table keeps the locking information? : Sql server administration
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is store procedure? How do they work?
