How to Check if a Column is Identity

How to Check if a Column is Identity – MS SQL

28 May 2010 562 views No Comment

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.

(No Ratings Yet)

Loading ...