title: SQL Server 2008 Create Table Syntax Error
body: <p>I'm trying to do a simple create table in SQL Server 2008 and receiving a syntax error.
  I am using Microsoft SQL Server Management Studio > New Query</p>
  
  <p>Here is the syntax:</p>
  
  <pre><code>CREATE TABLE Address
  {
      AddressID int IDENTITY PRIMARY KEY,
      Street varchar(60) NULL,
      City varchar(50) NULL,
      State varchar(2) NULL,
      Zip varchar(10)NULL,
      Intersection1 varchar(60) NULL,
      Intersection2 varchar(60) NULL
  }
  </code></pre>
  
  <p>And the error message:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 2<br>
    Incorrect syntax near '{'.</p>
  </blockquote>
  
  <p>The syntax appears to be accurate according to examples found online. What is the correct syntax for creating this table?</p>