DDL Flashcards
1
Q
TRUNCATE
A
Used to delete all rows from a table
Cannot be rolled back
Faster than DELETE
2
Q
DROP
A
Removes a table and cannot be rolled back
TRUNCATE
Used to delete all rows from a table
Cannot be rolled back
Faster than DELETE
DROP
Removes a table and cannot be rolled back