Differentiation of the commands should include the following:
- DROP
- removes a table from the database
- removes all of the tables’ rows, indexes, and privileges
- cannot be rolled back
- TRUNCATE
- removes all rows from a table
- cannot be rolled back
- is faster and does not use as much undo space as a DELETE
- DELETE
- removes rows from a table
- uses a WHERE clause to remove specified rows
- removes all rows, unless a WHERE condition is specified
- is made permanent or undoes changes by using COMMIT or ROLLBACK