I am looking for a way to query the 'MS_Description' extended property values of table columns that are returned in a view, not the extended property values on the view's columns itself.
I can get the view schema (How to list the source table name of columns in a VIEW (SQL Server 2005)) which returns view columns used in a view (although I only want columns that are returned).
And I can get extended properties: Select Extended Property from SQL Server tables
But I haven't worked out exactly how to marry the 2. But first, is there a built-in view or function that will automatically do this? I am using SQL 2014.
Or has anyone already written this query?