What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
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
How to get the definition of a view out of the sql server?
What is 1nf 2nf?
What are database states in ms sql server?
What is ms sql server index?
How do you create a data source?
Is BCNF better than 2NF & 3NF? Why?
Do you know how to send email from database?
Explain the difference between function and stored procedure?
How to download and install the scaled-down database adventureworkslt?
Explain unique key in sql server?
What will be the maximum number of index per table?
tell me the disaster recovery plan
Define self join in sql server joins?
How do I know if localdb is running?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.