I've used the COLUMNPROPERTY to Identify tables with Identity columns.

SELECT Distinct Table_Name,MAX(COLUMNPROPERTY (OBJECT_ID(Table_Name),Column_Name,'IsIdentity')) as Id

        FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK)

GROUP BY Table_Name