heap table 조사

--heap table 조사 

IF OBJECT_ID('tempdb..#t') IS NOT NULL 

DROP TABLE #t 

select db = DB_NAME(), NAME = OBJECT_NAME(123)  INTO #t from sys.indexes WHERE 1 = 0  

DECLARE @sql VARCHAR(2000) = 'use ? 

SELECT db_name(), x.NAME  FROM 

(SELECT * FROM sys.tables WHERE TYPE = ''U'') x 

INNER JOIN ( SELECT * FROM sys.indexes WHERE TYPE = 0) y 

ON x.OBJECT_ID = y.OBJECT_ID '

INSERT INTO #t 

EXEC sp_msforeachdb @sql 

DELETE  FROM #t WHERE db IN (SELECT NAME FROM sys.DATABASEs WHERE database_id <=4) 

OR db = 'distribution'

SELECT * FROM #t