SELECt [schema] = s.name, [table] = t.nameFROM sys.schemas AS sINNER JOIN sys.tables AS t ON s.[schema_id] = t.[schema_id]WHERe EXISTS ( SELECt 1 FROM sys.identity_columns WHERe [object_id] = t.[object_id]);

SELECt [schema] = s.name, [table] = t.nameFROM sys.schemas AS sINNER JOIN sys.tables AS t ON s.[schema_id] = t.[schema_id]WHERe EXISTS ( SELECt 1 FROM sys.identity_columns WHERe [object_id] = t.[object_id]);