Getting information of all the columns used in a view from any dbc tables

Database
Enthusiast

Getting information of all the columns used in a view from any dbc tables

All the column related information of all tables in captured in dbc.columns table.But I do not see the column information of views in that table.Is there any database table in dbc where all the metadata information of columns used in a view are captured?

2 REPLIES
Senior Apprentice

Re: Getting information of all the columns used in a view from any dbc tables

Hi,

Not until you get to TD16.0 at which point you get view DBC.ColumnsqV (and similar).

prior to that you have to 'roll your own'.

Cheers,

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: Getting information of all the columns used in a view from any dbc tables

To get all the information for one view until release 16:

HELP COLUMN <viewname>.*;