title: SQL Server error: Incorrect syntax near 'MODIFY'. in my query
body: <p>This is the query that I am trying to execute</p>
  
  <pre><code>use [warz]
  go
  
  ALTER TABLE dbo.items_lootdata
  MODIFY TABLE [RecordID] [int] IDENTITY(1,1) NOT NULL
  go
  </code></pre>
  
  <p>I got the error: </p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 3<br>
    Incorrect syntax near 'MODIFY'.</p>
  </blockquote>
  
  <p>Any ideas?</p>