Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 19382 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
Which are new data types introduced in sql server 2008?
What is subreport?
What do you understand by physical_only option in dbcc checkdb?
What is read uncmmited?
What are temporal tables in sql server 2016?
Mention the differences between local and global temporary tables.
What is it unwise to create wide clustered index keys?
What are the tools available in market as an alternative to sql server reporting services?
Explain filtered indexes?
What is self contained sub query?
what stored procedure can you use to display the current processes? : Sql server administration
When does a workload on SQL Azure get throttled?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is parameterized reports in ssrs ?
explain different types of cursors? : Sql server database administration
