Skip to Content

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

Important

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 13.1