title: get basic SQL Server table structure information
body: <p>I can get the number of columns in an SQL Server database with this:</p>
  
  <pre><code>SELECT COUNT(*)
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE table_name = 'Address'
  </code></pre>
  
  <p>But is there any way (for an unknown number of columns) I can get the name and datatype and length of each column?</p>