DATABASE - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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

Syntax

DATABASE database ;

Syntax Elements

database
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 Vantage.
*** New default database accepted.