Interested to Buy Any Domain ? << Click Here >> for more details...
What's the difference between DELETE TABLE and TRUNCATE
TABLE commands?
- 9 Answers
- 18988 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajay
DELETE Command
•It will delete record by record
•Execution is slow
•It is a logged command, so data
can be Restore after delete
•Condition can be applied with delete.
•It will fire trigger.
TRUNCATE Command
•It will delete all the records at the Same time.
•Execution is fast.
•It is not a logged command, so data can’t
be Restore after Truncate.
•Condition can’t be applied.
•It will not fire the trigger.
ajay.thomala@gmail.com
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is page in sql server?
How to enter binary string literals in ms sql server?
What are logical/boolean operations in ms sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
can an order by clause be used in a creation of a view?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is CTE in SQL
What is the difference between drop table and truncate table?
Mention the differences between local and global temporary tables.
Explain about link server in sql server?
How can you find out how many rows returned in a cursor?
How to set the current database in ms sql server?
What is the difference function and stored procedure?
What is an index in a database?
How to compare the top two records using sql?
