Which SQL command deletes all rows from a table without deleting the structural schema, cannot be rolled back easily in some systems, and does not fire delete triggers?
Explanation:
TRUNCATE is a DDL command that quickly removes all records from a table by deallocating the data pages, bypassing row-level logging and triggers while leaving the table structure intact.
No comments yet. Be the first to start the discussion!