Purpose
The HELP command returns syntax information about dul commands and lists the tables, views, and macros stored in a database.
Syntax
HELP { DATABASE database | DUL } ;
- 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: Listing tables, views, and macros in the crashdumps database
To list all tables, views, and macros in 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