<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>

sys.columns.is_identity = 1
e.g.,
```
```
select o.name, c.name
from sys.objects o inner join sys.columns c on o.object_id = c.object_id
where c.is_identity = 1
```
```