DELETE 구문을 사용하면 테이블 내에 불필요한 데이터를 삭제할 수 있다.
DELETE
FROM table
_spec [ correlation
]
[ WHERE
search_condition
] [ ; ]
correlation
:
[ AS
] identifier
[ {, identifier }_
]
table_spec
:
single_table_spec
( single_table_spec [ {,
single_table_spec
}_ ] )
single_table_spec :
[ ONLY
] table_name
ALL table_name
[ EXCEPT
table_spec
]
DELETE FROM stadium;
DELETE FROM olympic WHERE host_year = 1980;