如何获取具有标识列的所有表的列表

如何获取具有标识列的所有表的列表

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]);