DELETE DATABASE
Purpose
DELETE DATABASE deletes the contents of one or more databases, including all objects except for journal tables.
To drop a journal table contents and structure, use the SQL statement MODIFY DATABASE with the DROP JOURNAL TABLE option. Refer to SQL Request and Transaction Processing for more information.
Syntax
where
Syntax Element |
Description |
(dbname) |
Name of the database. |
ALL |
Indicates the operation affects the named database and its descendants. |
EXCLUDE |
Protects the named database from deletion. |
(dbname) |
Name of the database to protect from deletion. |
ALL |
Indicates the operation protects the named database and its descendants. |
(dbname1) TO (dbname2) |
Alphabetical list of databases to protect from deletion. The delimiting database names need not identify actual databases. Database DBC is not part of a range. |
Usage Notes
To delete a database, the user name specified in LOGON must have DROP privilege on the database to be deleted.
To delete a database that is partially restored but unusable, delete the database with DELETE DATABASE. Executing the statement deletes all access privileges for all objects in the database. To release the locks that remain after the restore, run RELEASE LOCK before using DELETE DATABASE.