All Type Coding

Search Here

Differencebetween Delete and Truncate command in sql server.

Delete Command
                                                       The SQL DELETE statement is a used to delete a one or more records from a table.A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed.

Truncate Command-

                                                   The SQL TRUNCATE command is used to delete all the rows from the table and free the space containing the table.



There are some difference between delete and truncate command these are given below.







9. In case of TRUNCATE ,Trigger doesn't get fired.But in DML commands like DELETE .Trigger get fired.

No comments :

Post a Comment