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