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