The main requirement I have is to compare the column names, types and length of 2 different views in Teradata.
As you already know dbc.columns will have that information for TABLES but not for VIEWS.
Using HELP COLUMN .* will give all this information.
I have two questions (any of them resolved would do it =D): 1) how can I use this information in a query? ... to make the comparison I need to make between two views Or 2)where is this HELP statement getting the info so I can get the information from there also?