Use HELP COLUMN information

Database

Use HELP COLUMN information

Hi all,

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?


Thanks in adnvance for your help