title: Any way to retrieve SQL Field Description property with a datarows query?
body: <p>I have a ProductInventory table with over 100 fields.  Many need to offer user guidance to understand.  I’m looking for a way to add tooltips to the form without hardcoding the text.</p>
  
  <p>I want to use MS SQL table field property DESCRIPTION as the source for user tooltips during web forms data entry.</p>
  
  <p>Generally, my descriptions are for other db admins, but I was wondering if with a little more thoughtful and friendly descriptions, I could make duel use of this extended SQL field property.</p>
  
  <p>Is is possible to retrieve this field property WITH a datatable/dataset query?</p>
  
  <p>Example:</p>
  
  <p>FieldName: ProductID
  Value: [string]
  FieldDescription: “This is a description for the end user of what the ProductID  is field used for”</p>
  
  <p>I know we can get the field schema for a specific field by…</p>
  
  <pre><code>SELECT @Result = count(1) 
  FROM   ::fn_listextendedproperty (N'MS_Description',  N'Schema',  'dbo', 
  N'Table',   '[Your Table Name]', 
  N'Column',  '[You Field Name]')
  </code></pre>
  
  <p>Is this possible without a “per field” query on each field?</p>
  
  <p>Perhaps run two queries. One to pull records and one to pull schema.
  (i.e.  retrieve entire table schema and do a loop to find matching field name.)</p>
  
  <p>Any thoughts?</p>