DELETE FROM { <class specification> | <meta class specification> }
[ WHERE <search condition> ]
[ <using index clause> ]
DELETE FROM employee;
DELETE FROM ONLY hotel WHERE name = 'Hilton';
DELETE FROM location
WHERE lodging IN (SELECT name FROM resort);