Explain the difference between DELETE and TRUNCATE commands.

The DELETE command is used by professionals to remove particular rows from a table based on a condition, allowing you to selectively delete records. TRUNCATE, on the other hand, removes all rows from a table without specifying conditions. TRUNCATE is faster and uses fewer system resources than DELETE but does not log individual row deletions.


Comments

Leave a Reply

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