The difference between Truncate and Delete in Microsoft SQL Server

TipsMake.com - In the following article, we will help you distinguish some basic differences between the DELETE and TRUNCATE TABLE syntax in Microsoft SQL Server application. Basically, both of these statements help us to remove the data, but in essence it is not so.

DELETE statement

This command will help us delete the records - Record from the database in rows - Row . When such a record is deleted with DELETE , all internal components are recorded in the Transaction Log section, the binding parts are checked, and any redundant components are completely deleted. In addition, the logs if accidentally deleted with this DELETE command can still be recovered. While DELETE is often used to delete table data from tables more often when applied in certain data sections, besides, this statement is often used for single data tables, or in the case of want delete data from a certain table when needed in conjunction with many other relational tables. On the other hand, delegating DELETE functions on the table is only applied on different user accounts without having to assign ownership on that account. And the DELETE statement does not change the automatic increase or decrease of the number of columns - Column in the table containing that data.

General syntax:

 [WITH [, . n]]
 DELETE 
 [TOP (expression) [PERCENT]] 
 [FROM] 
 {table_name [WITH ([. n])] 
 | | view_name view_name 
 | | rowset_function_limited rowset_function_limited 
 | | table_valued_function table_valued_function 
 } } 
 [ 
 ] 
 [FROM [, . n]] 
 [WHERE { 
 | {[CURRENT OF 
 {{[GLOBAL] cursor_name} 
 | cursor_variable_name 
 } 
 ] 
 } 
 } 
 ] 
 [OPTION ([, . n])] 
 [; ]