title: SQL Server metadata: How to get description for columns in views
body: <p>SQL Server allows storing metadata like description for a table and its columns. The description for the columns can be retrieved from sys.extended_properties. There is also a way to set the description for a view (using the properties window). But there is no way (or at least I am not aware of at this moment) to put the description of a column in a view.</p>
  
  <p>For a particular development, we are keeping the descriptions in the database itself. This allows us to keep it in a single place and do a reporting on it.</p>
  
  <p>We wished to extend the same to include the views as well. </p>
  
  <p>Can somebody help in this?</p>