1DELETE FROM table_name WHERE condition;
2-- Ex.
3DELETE FROM Customers WHERE CustomerName='Mustafa Mbari';
1-- Drop, but no space gain
2DROP TABLE table_name;
3-- Really frees space (Oracle)
4DROP TABLE table_name PURGE;
1Deletes a table from a database.
2Example: Removes the users table.
3DROP TABLE users;