• I use the following script to get the tables having identity values....

    SELECT table_name

          ,column_name

          ,IDENT_CURRENT(table_name) as Identity_value

          ,data_type

     FROM information_schema.columns

    WHERE COLUMNPROPERTY(OBJECT_ID(table_name),column_name,'IsIdentity')=1

    ORDER BY table_name

    Why bother with system tables, when you can get the same with schema view and functions?