17.10 - DATABASE - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

The DATABASE command changes the default database for the current Vantage session.


DATABASE database ;

Syntax Elements

Name of the new default database.

Usage Notes

When you invoke dul and log onto the database, the crashdumps database automatically becomes your default database. Vantage uses the database specified in the DATABASE command as the default database until the end of the session, or until you type a subsequent DATABASE command.

To use the DATABASE command, you must have SELECT privileges on the specified database.

Example: Changing the default database

To make the Personnel database the default database for the current session, type the following:

DATABASE Personnel ;

The following appears:

*** Sending database Personnel to Teradata Database.
*** New default database accepted.