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 DatabaseName.TableName returns column definition
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.*