15.10 - DEFAULT DATABASE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

Default database established each time this user logs onto Teradata Database.

The default is the user name associated with the current session.

database_name
Name of the default database.
database_name need not be an existing database. However, Teradata Database returns an error when you try to create or reference an object within a nonexistent database or if the default database is null.

Example: Modifying the Default Database and Password for a User

Change user the default database and password for chin.

     MODIFY USER chin AS 
     DEFAULT DATABASE = personnel, 
     PASSWORD = nitram;