Post
Ask Question

Find Which Are All Table has Set Identity

Find which are all table has set identity.
  1. select COLUMN_NAME, TABLE_NAME  
  2. from INFORMATION_SCHEMA.COLUMNS  
  3. where TABLE_SCHEMA = 'dbo'  
  4. and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1   
  5. order by TABLE_NAME