What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
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
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is 5nf in normalization form?
What is the benefit of normalization?
Do you know what is lock escalation?
Do you know what are the ways available in sql server to execute sql statements?
What is the difference between delete and truncate statements?
explain different types of joins? : Sql server database administration
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is subquery in sql?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are the different types of collation sensitivity in sql server?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
What does the not null constraint do?
What is difference between join and natural join?
What is an execution plan? How would you view the execution plan?