Thread: How to Check if a Column is Identity - MS SQL

How to Check if a Column is Identity in MS SQL

SELECT name, is_identity
FROM sys.columns
WHERE [object_id] = object_id('MyTable')

This will list all the table column names with is_identity column value set to 1 if the column is identity.