title: How To Create Table with Identity Column
body: <p>I have an existing table that I am about to blow away because I did not create it with the <code>ID</code> column set to be the table's Identity column.</p>
  
  <p>Using <strong>SQL Server Management Studio</strong>, I scripted a <em>"Create To..."</em> of the existing table and got this:</p>
  
  <pre><code>CREATE TABLE [dbo].[History](
      [ID] [int] NOT NULL,
      [RequestID] [int] NOT NULL,
      [EmployeeID] [varchar](50) NOT NULL,
      [DateStamp] [datetime] NOT NULL,
   CONSTRAINT [PK_History] PRIMARY KEY CLUSTERED 
  (
      [ID] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>
  
  <p>My question is, how would I modify this <code>SQL</code> so that my resulting table has the <code>ID</code> column set as the <strong>Identity</strong>?</p>