title: How do you determine what SQL Tables have an identity column programmatically
body: <p>I want to create a list of columns in SQL Server 2005 that have identity columns and their corresponding table in T-SQL.</p>
  
  <p>Results would be something like:</p>
  
  <p>TableName, ColumnName</p>