DROP TABLESPACE statement

The DROP TABLESPACE statement removes a table space and all of its dependent objects.

GUID-53F34271-899E-4E1D-B758-9359E6F6D7E1-low.png

To drop a table, you must have one of the following privileges:

  • Ownership of the object
  • DBADM authority
  • PACKADM authority for the collection or for all collections

DROP TABLESPACE databaseName. tableSpaceName

This option specifies the fully qualified name of the table space to be dropped.


Related topic

CDL-statements



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*