Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19090 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreedhar
Truncate is DDL command, Delete is a DML command.
Delete operation can be rolled back and in truncate we
can't.
Where caluse can be used in Delete and not in Truncate.
Truncate table less time than delete in execution
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the steps you must follow to hide sql server instances?
What is service broker?
What is the difference between char, varchar and nvarchar?
What is the difference between upgrade and migration in sql server?
Do you know what are acid properties of transaction?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
what are constraints? : Sql server database administration
how to take backup bcp out for a column in table in sql server?
Name and describe few console utilities for ssrs?
How do I find information about the install locations for the various instances running on a computer?
What is the difference between a local and a global temporary table?
How to add more data to the testing table in ms sql server?
What is extent? Types of extents?
What is merge replication?
