Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19036 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 is SQL Azure Firewall?
Explain the properties of subqueries in sql server?
How to copy data from one table to another table?
What according to you is the difference between mysql and sql server performance?
What are the different authentication modes in sql server? How can it be changed?
What is change tracking in sql server?
How to assign new column names in a view?
How to list all triggers in the database with sys.triggers in ms sql server?
How do users use Report Builder with SQL Server data sources?
What are the main differences between #temp tables and @table variables and which one is preferred?
How can sql server instances be hidden?
How to bind a view to the schema of the underlying tables?
What is cdc in sql server?
How do you handle datasets larger than 50 gb?
What are cursors in ms sql server?
