DELETE 문

<delete statement>

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);