DROP TABLESPACE
tablespace [
INCLUDING CONTENTS
[
AND DATAFILES
] [
CASCADE CONSTRAINTS
]];