22,302
社区成员




EXEC sp_pkeys 'table1'
DECLARE @sql nvarchar(max)
SET @sql = (
SELECT N'UNION ALL SELECT '''+name+N''' name, COUNT(*) cnt FROM ['+name+N'] '
FROM sys.objects
WHERE type='U'
FOR XML PATH('')
)
SET @sql = N'
SELECT *
FROM ('+STUFF(@sql,1,9,'')+N') t
WHERE cnt=0'
--PRINT @sql
EXEC(@sql)