16.20 - DEFAULT DATABASE - Teradata Database - Teradata Vantage NewSQL Engine

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;