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

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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;