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.
