What is the difference between DROP and TRUNCATE?
They both refer to the same operation of clearing the table, but keeping its definition intact.
DROP deletes table completely, removing its definition as well. TRUNCATE clears the table but does not delete the definition.
They both refer to the same operation of deleting the table completely.
TRUNCATE deletes table completely, removing its definition as well. DROP clears the table but does not delete the definition.