how to extract data type and length of all columns of all tables in teradata

Database
Not applicable

how to extract data type and length of all columns of all tables in teradata

Hi all,

I have all the columns of all the tables to be of varchar data type and of length 255. How do i check for the data type and length for all the tables in one go instead of checking for each table?

Thanks!!
Avi
1 REPLY
WAQ
Enthusiast

Re: how to extract data type and length of all columns of all tables in teradata

Do a select on dbc.columns table