I have been googling and searching this site but cant find an answer to this simple question.

How can I list or select all the columns of a table in Teradata?

1

1 Answer

different possibillities

Help table <TableName> -- All columns of a table Help columns <ViewName>.* -- All columns of a View Show table <TableName> -- DDL of table Show view <ViewName> -- DDL of View show select * from <ViewName>-- DDL of base table in a view

or select from system table.

SELECT ColumnName FROM dbc.columnsV WHERE DatabaseName = 'DB_NAME' and TableName = 'table_name';

Searching for teradata column name list gives some more answers.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.