title: How to query a view's column's extended properties from the underlying source table?
body: <p>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.</p>
  
  <p>I can get the view schema (<a href="https://stackoverflow.com/questions/12000999/how-to-list-the-source-table-name-of-columns-in-a-view-sql-server-2005">How to list the source table name of columns in a VIEW (SQL Server 2005)</a>) which returns view columns used in a view (although I only want columns that are returned).</p>
  
  <p>And I can get extended properties: <a href="https://stackoverflow.com/questions/6714848/select-extended-property-from-sql-server-tables">Select Extended Property from SQL Server tables</a> </p>
  
  <p>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.</p>
  
  <p>Or has anyone already written this query?</p>
  
  <p><a href="http://www.sqlfiddle.com/#!6/e3abc/1" rel="nofollow noreferrer">http://www.sqlfiddle.com/#!6/e3abc/1</a></p>