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*