Duplicate Databases - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Duplicate Databases

If a message indicates there is a duplicate database, there might be a database or user that starts with a blank character that is exactly the same as another database or user name. The database or user with the blank at the beginning of the name does not load into the database tree. If this database or user was created in error, use the following procedure to drop it.

To drop a duplicate database or user

✔ In the Query window, type the following where the duplicate name is dbname.

The quotes and blank character are required.

DROP DATABASE “ dbname”

or

DROP USER “ dbname”

For more information, see “Drop a Database or Database Object” on page 46.