DELETE DATABASE - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.