What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 16413 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
What happens when transaction log is full?
What is page-level compression?
Which sql server table is used to hold the stored procedure script?
What are transactions in sql?
How to restore performance issues and how to check?
What is a transactions?
Determine how to use the inserted and deleted pseudo tables?
What is a schema in ms sql server 2005?
How do I view a script in sql server?
How can you insert null values in a column while inserting the data?
Why I am getting this error when dropping a database in ms sql server?
Do you know sql server 2008 backup compression?
What is the maximum number of index per table?
Explain powershell included in sql server 2008?
How does Report Builder support Analysis Services cubes?
