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 TABLE statement

The DROP TABLE statement removes a persistent or global temporary table definition.

GUID-A6EC42AC-237B-438F-8F3B-59AD4CDB0195-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 TABLE tableOwner.tableName

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


Related topic

CDL-statements




 

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