Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19040 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 is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is normalization and what are the advantages of it?
When I delete any data from a table, does the sql server reduce the size of that table?
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?
Explain user defined functions?
List the different types of joins?
Explain about Views?
What is a database in ms sql server?
How to disable triggers using "disable trigger"?
What is sql azure database?
Define primary key?
what's sql server? : Sql server database administration
Define views.
Explain the collation?
What happens if the update subquery returns multiple rows in ms sql server?
