- Product Reviews
- Find Me
- Connect With Me
Find which are all table has set identity.
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
I am Sibeesh Venu, an Engineer by Profession and Writer by Passion. 2 times Microsoft MVP, 3 times C# Corner MVP, DZone MVB, Author, Speaker, Full Stack Developer.