Is there a query that I can use in Query Tool to get View Owner, Names and their Columns?
Query to get View Owner, Names and their Columns.
This query will give the View Columns as long as they are visible in the Views. If they are just in User Defined SQL those we cannot query on.
V.SCHEMA_NAME 'View Owner',
V.USER_FORMATTED_NAME 'View Name',
A.USER_FORMATTED_NAME 'View Column Name'
LEFT JOIN MODEL M
ON M.ID@ = V.OWNER@
LEFT OUTER JOIN ATTRIBUTE A
ON V.ID@ = A.OWNER@