您可以执行另一个（自我）连接到sys.objects表来限制表格，例如

You can do another (self) join to the sys.objects table to restrict the tables e.g.

SELECT TABS.name, CONS.name, CONS.type_desc
FROM sys.objects TABS
JOIN sys.columns COLS ON TABS.object_id = COLS.object_id
JOIN sys.objects CONS ON TABS.object_id = CONS.parent_object_id AND CONS.type_desc LIKE '%CONSTRAINT'
WHERE TABS.type_desc='USER_TABLE'
AND SCHEMA_NAME(TABS.schema_id) = 'dbo'
AND COLS.is_identity = 1