DESCRIBE TABLE shows the columns related information in most of the popular RDBMS like ORACLE, MySQL, etc. There is no Describe Table command available in Teradata.
Teradata provides two alternative ways to view the columns related information. They are as below.
- HELP TABLE
- SHOW TABLE
Syntax
Below are the syntax of Teradata HELP TABLE and SHOW TABLE.
HELP TABLE DatabaseName.TableName; SHOW TABLE DatabaseName.TableName;
Where,
- DatabaseName – The name of the database where the table belongs.
- TableName – The name of the table whose information you want to check.
HELP TABLE returns only the column definitions whereas the SHOW TABLE command shows the full create table statement.
Example
The below examples show the information about the employee table.
HELP TABLE Teradatapoint.employee;
Output:-
SHOW TABLE Teradatapoint.employee;
Output:-
