HELP/SHOW TABLE command

For folks who ask is there something similar to a command “describe table” in Teradata:

use the HELP or SHOW TABLE commands as needed.

HELP TABLE

HELP TABLE DatabaseName.TableName returns column definition

SHOW TABLE

Once the table is created, you can use SHOW TABLE command to view the FULL Definition of the table.

SHOW TABLE Employee;

*** Text of DDL statement returned.

*** Total elapsed time was 1 second.

————————————————————————

CREATE SET TABLE EMPLOYEE ,FALLBACK , etc… shows the full statement here

 

SELECT * FROM dbc.Tables

HELP COLUMN x.*

Leave a Reply

Your email address will not be published. Required fields are marked *