15.10 - Database Name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
database_name
Name of the database for which information is requested.

Example: HELP DATABASE

The following request returns the following information about the personnel database.

     HELP DATABASE personnel;
    Table/View/Macro Name Kind Comment  Protection    Creator Name
    --------------------- ---- -------  -----------   --------------
    Department            T                       F   Administration
       .                  .                       .      .
       .                  .                       .      .

Example: HELP DATABASE Output Showing a UDT and a Method

The following example shows that there is a UDT named euro and a method named euro_To_US in the SYSUDTLIB database.

     HELP DATABASE SYSUDTLIB;
     Table/View/Macro name euro
                      Kind U
                   Comment ?
                Protection F
              Creator Name USER1
             Commit Option N
           Transaction Log Y
     Table/View/Macro name euro_To_US
                      Kind H
                   Comment ?
                Protection F
              Creator Name USER1
             Commit Option N
           Transaction Log Y

Example: Output with a UIF

For installed files, the HELP DATABASE Kind column displays Z.
HELP DATABASE db1;
Table/View/Macro name          Kind  Comment
------------------------------ ---- -------------------------------
                         ft1     L     ?
                ft1_contract     C     ?
                      map_fn     Z     ?