title: Use a Query to access column description in SQL
body: <p>I am trying to access the Column description properties using the INFORMATION_SCHEMA </p>
  
  <p>I have created this Query in the past to get the column name but i can not figure out how to get description of the column</p>
  
  <pre><code>SELECT COLUMN_NAME AS Output, ORDINAL_POSITION 
  FROM INFORMATION_SCHEMA.COLUMNS 
  WHERE  (TABLE_NAME = @Tablename) AND (ORDINAL_POSITION = @Location)
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/lLCdp.png" alt=" Screen shot "></p>
  
  <p>This is where the Description is on the field properties</p>