Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see ALTER and BMC AMI Change Manager for Db2 13.1.

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*