15.10 - DEFAULT DATABASE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;