Difference between Truncate table and Delete Table

1)Delete Command

1)It supports where clause and hence it can be used to delete all rows from table or specified rows from table
2)It deletes row one by one
3)Delete commnad is DML command
4)When all rows are deleted from table using delete command then identity available on table will not be reset to its seed


2)Truncate Command

1)It doesnt supports where clause and hence it can be used to delete all rows from table
2)It deletes row page by page
3)Delete commnad is DDL command
4)When all rows are deleted from table using delete command then identity available on table will  be reset to its seed

Ebook Download
View all
SQL Jobs
Read by 0 people
Download Now!
Learn
View all