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

Database
N/A

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