Find Which Are All Table has Set Identity

Find which are all table has set identity.
[sql]
select COLUMN_NAME, TABLE_NAME
from INFORMATION_SCHEMA.COLUMNS
where TABLE_SCHEMA = ‘dbo’
and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, ‘IsIdentity’) = 1
order by TABLE_NAME
[/sql]

Leave a Reply

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

Serverless 360