Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18994 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 is change data capture (cdc) in sql server 2008?
explain databases and sql server databases architecture? : Sql server database administration
Explain an incremental backup?
How to drop an existing table?
What happens if you add a new index to large table?
Explain system scalar functions?
Why we use functions in sql server?
What is a heap?
Tell me extended events in sql server 2008?
How to create function with parameter in sql server?
What is Cross Join and in which scenario do we use Cross Join?
Explain the categories of stored procedure?
How can you check the version of sql server?
What is user-defined multi-statement table-valued function?
Explain about sql server login?
