TeraData SHOW command

The Teradata Database offers several types of help using an interactive client.

There are times when you need to recreate a table, view, or macro that you already have, or you need to create another object of the same type that is either identical or very similar to an object that is already created. When this is the case, the SHOW command is a way to accomplish what you need. The intent of the SHOW command is to output the CREATE statement that could be used to recreate the object of the type specified.

SHOW TABLE <table-name>; 
Displays the CREATE TABLE statement needed to create this table.

TeraData HELP Command

HELP Command in Teradata plays a important role, This is something like “DESCRIBE” command in Oracle and DB2. This will display the object details.

The HELP Command is used to display information about database objects such as
●     Databases and Users
●     Tables
●     Views
●     Macros

List the tables in TeraData

For listing all the tables, views and macro , execute any sql from below as per need

a) select * from dbc.tables;