Description
Is there a query that I can use in Query Tool to get View Owner, Names and their Columns?
Solution
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.
SELECT
V.SCHEMA_NAME 'View Owner',
V.USER_FORMATTED_NAME 'View Name',
A.USER_FORMATTED_NAME 'View Column Name'
FROM
VIEW V
LEFT JOIN MODEL M
ON M.ID@ = V.OWNER@
LEFT OUTER JOIN ATTRIBUTE A
ON V.ID@ = A.OWNER@
Comments
0 comments
Please sign in to leave a comment.