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.
Explanation:
A Weak Entity is an entity that does not possess its own primary key and depends on an identifying relationship with a strong (owner) entity.
No comments yet. Be the first to start the discussion!