17.00 - DEFAULT DATABASE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Last Update
2021-01-23

The default database established each time a user with this profile logs onto Vantage. A change to the default database takes place at the next user logon.

Vantage returns an error if a profile member user tries to create or reference an object within a nonexistent database.

If the default database is NULL or is not defined in the profile assigned to a user, Vantage uses the setting defined for the individual user.

database_name
Name of the default database.