Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18982 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 basic features of a trigger in ms sql server?
What is normalization? Explain its different types?
Does the order of columns in update statements matter?
What is the main purpose of having conversation group?
What does top operator do?
Can we use where and having clause together?
Can we use where clause in union?
Disadvantages of the indexes?
Explain the first normal form(1nf)?
Tell me extended events in sql server 2008?
How do I create a stored procedure in sql server?
What is indexing in sql server with example?
Explain sql server service broker?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Can foreign key be deleted?
