| Sno | TRUNCATE | DELETE |
| 1 | TRUNCATE is faster | Comparitively slower. |
| 2 | Removes all rows from a table | Can remove specific rows with Where clause |
| 3 | Can not be Rolled back. | Can be. |
| 4 | Is DDL | Is DML Command. |
| 5 | Resets identity of the | Does not. |
| 6 | Removes the data by deallocating the data pages and | Removes one row at a time and records an entry in |
www.codecollege.NET
0 comments
Post a Comment