15.00 - HELP - 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

HELP

Purpose  

The HELP command returns syntax information about dul commands and lists the tables, views, and macros stored in a database.

Syntax  

 

Syntax element …

Returns a …

DATABASE database

list of tables, views, and macros stored in the specified database.

DUL

syntax summary of all the commands available with the dul utility.

Example

To list all tables, views, and macros on the Crashdumps database, type the following:

HELP DATABASE Crashdumps ; 

The following appears:

*** Sending HELP DATABASE crashdumps; to Teradata Database.
*** Help information returned. 10 rows. 
   Crash_20000526_134503_01 
   Crash_20000526_154702_01 
   Crash_20000526_154925_01
   Crash_20001120_103233_01
   Crash_20001225_163434_01

If the database does not exist, the following appears:

help database non_exist;
*** Sending HELP DATABASE non_exist; to Teradata Database.
*** Failure 3802 Data base 'non_exist' does not exist.
                Statement# 1, Info =0