title: SQL comments on create table on SQL Server 2008
body: <p>I need to create some pretty big tables in SQL Server 2008. While I do have <a href="https://en.wikipedia.org/wiki/SQL_Server_Management_Studio" rel="nofollow noreferrer">SQL Server Management Studio</a> (SSMS), I would like to comment the tables and the columns when I create the table. How do I do this?</p>
  <p>An example of the query I am running:</p>
  <pre><code>CREATE TABLE cert_Certifications
  (
    certificationID int PRIMARY KEY IDENTITY,
    profileID int,
    cprAdultExp datetime null
  )
  </code></pre>
  <p>I've tried COMMENT'Expiration Date for the Adult CPR' and COMMENT='Expiration Date for the Adult CPR' after the data type, and SQL Server is giving me an error.</p>