data science FAQ's

Difference between delete and truncate commands

DELETE command is used in conjunction with WHERE clause to delete some rows from the table. This action can be rolled back.

However, TRUNCATE is used to delete all the rows of a table and this action cannot be rolled back.

Leave a Reply

Your email address will not be published. Required fields are marked *