What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 17347 Views
- I also Faced
- E-Mail Answers
Answer Posted / radh
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 ? | 27 Yes | 1 No |
Post New Answer View All Answers
What are audit control procedures?
What are the rendering extensions of ssrs?
How do I install only the client tools of sql server 2000?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is unpivot?
Do you know spatial data types - geometry and geography in sql server 2008?
how to avoid cursors? : Sql server database administration
When we should use and scope of @@identity?
how many bits ip address consist of? : Sql server database administration
Can you please explain the difference between function and stored procedure?
Explain the difference between function and stored procedure?
What is triggers and its types?
How to provide default values to function parameters?
where can you add custom error messages to sql server? : Sql server administration
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
