15.00 - DATABASE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DATABASE

Purpose  

The DATABASE command changes the default database for the current Teradata Database session.

Syntax  

 

Syntax element …

Is the …

database

name of the new default database.

Usage Notes  

When you invoke dul and log onto the Teradata Database, the Crashdumps database automatically becomes your default database. The Teradata Database 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  

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.