In addition to the command that shows column information, in the section Basic Teradata Learning Tips, there are a few more useful help commands that show information about various database objects.

To display checks to be made on the data before it is inserted and also columns those are involved in this check.

HELP CONSTRAINT <table name>.<constraint-name>

To display names of all the tables, views, macros and also triggers those are stored in a database.

HELP DATABASE <database name>

To display indexes (for join index use the keyword JOIN before INDEX) of a table with the type as unique or non-unique including the column names.

HELP INDEX <table name>

To display detail characteristics of a Macro with parameters passed to it during run time, type

HELP MACRO <macro name>

To display detail characteristics of a Procedure with parameters passed to it during run time, type the following command.

HELP PROCEDURE <procedure name>

To display all the session information including user name, account name, logon date, database name and a lot more.

HELP SESSION;

To display all the statistics of a data like date and time inserted/updated, unique values, column names etc.

HELP STATISTICS <table name>

To display all the column information of a table like type, null able, format, max length etc.

HELP TABLE <table name>

To display details of a trigger like time and sequence of execution etc. type the following command.

HELP TRIGGER <trigger name>

To display detail characteristics of a like type, null able, format, max length etc. type the following command.

HELP VIEW <view name>;

You can also use any SQL keyword to get more information about it. Remember when you are using a keyword with the HELP command; you need to put the keyword inside single quote, as follows;

HELP ‘SQL’; (This gives a list of SQL commands present in Teradata)

HELP ‘SQL SELECT’; (To know more about the select statement)

HELP ‘FASTLOAD’ ;( To know more about FASTLOAD command)

Our Random Articles

More Links