Skip to Content

 

  

Information
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 DATABASE statement

The DROP DATABASE statement removes a database and all of its dependent objects.

GUID-CB8BF59F-2063-4A02-872E-655FD72D81A7-low.png

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

  • The DROP privilege on the database
  • DBADM or DBCTRL authority for the database
  • SYSADM or SYSCTRL authority
Warning

Note

You cannot use a DROP DATABASE statement to implicitly drop a global temporary table. Global temporary tables must be dropped in DROP TABLE statements.

DROP DATABASE databaseName

This option specifies the name of the database to be dropped.


Related topic

CDL-statements





 

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

ALTER and BMC AMI Change Manager for Db2 12.1