15.10 - Duplicate Databases - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K

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.

  • 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.