title: Add Identity column to all the tables in database Sql server 2005
body: <p>I have a database that is used to transfer data across the main production database when we import data from a third party.</p>
  
  <p>I would like to add an <code>Identity</code> column to each table.</p>
  
  <p>I know that the below SQL will do for a single table, how can I do it for all the tables in the database?</p>
  
  <pre><code>ALTER TABLE dbo.YourTable
  ADD Id INT IDENTITY(1,1) NOT NULL
  </code></pre>
  
  <p>Many thanks</p>