Software QA (13)
SQL Server (1)
What is the difference between DELETE TABLE and TRUNCATE TABLE commands
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?
Following are difference between them
? DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table so TRUNCATE table is faster as compared to delete table.
? DELETE table can have criteria while TRUNCATE can not.
? TRUNCATE table can not trigger.
2007-10-25, 4814👍, 0💬
I have 5 questions please give me the answer ,explanation,suggestions if any?? what is PMP(project m...
How To Analyze Tables with "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Serve...
How Oracle Handles Dead Locks? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle se...
What is thread? A thread is an independent path of execution in a system.
How To Add Column Headers to a Table? - XHTML 1.0 Tutorials - Understanding Tables and Table Cells I...