Metadata information for a view

Database

Metadata information for a view

If i query dbc.columns for a particular table within a database it gives me column data type with its length.However if i have a custom view that is build on top of lets suppose 2 tables and if i query dbc.columns for this view it won't give me the column datatypes or length of columns in the view.

Any suggestion on how can i get column datatype and length of the columns in this custom view.

3 REPLIES

Re: Metadata information for a view

You can try something like below -

SELECT TOP 1 TYPE(col1),TYPE(col2),...,TYPE(coln) FROM dbname.viewname

Re: Metadata information for a view

Thank you

Teradata Employee

Re: Metadata information for a view

HELP COLUMN dbname.viewname.*;