Check Identity

This will list out identity columns in a Database. This is compatible to SQL 2005 only.


select as ColumnName, as tableName from sys.columns a, sys.tables b
where a.object_id = b.object_id and a.is_identity = 1

Leave a Reply

Leave a comment

Your email address will not be published. Required fields are marked *