Columntype of a column in a view

Question

Is there any way to find the column type of the columns in a view. For example for tables we can fire select Columntype from dbc.tables where tablename=:name and databasename=:name;

But for views the above query always returns null value.

Answer 1

This is the only way to get detailed metadata for views columns:

help column databasename.tablename.*;