HELP Commands in Teradata Database objects

The HELP Command is used to display information about Teradata database objects such as -

Databases and Users ,Tables ,Views  and Macros.

HELP fetches information about above mentioned objects from the Teradata Data Dictionary.

There are various HELP command available in Teradata.

HELP Command

HELP DATABASE databasename; 

HELP USER username;

HELP TABLE tablename;

HELP VIEW viewname;

HELP MACRO macroname;

HELP COLUMN table or viewname.*;  (to show all columns) 

HELP COLUMN table or viewname.colname . . ., colname; 

HELP INDEX tablename;

HELP STATISTICS   tablename; 

HELP CONSTRAINT constraintname;

HELP JOIN INDEX join_indexname;

HELP TRIGGER triggername;