T_SQL::미 사용 Table

미사용 Table 목록

?

1 2 3 4 5 6 7 8 9 10 11

SELECT  idx.object_id, OBJECT_NAME(IDX.object_id) as object_name,         max(ps.row_count) as row_count,         max(obj.create_date) as create_date,         max(obj.modify_date) as modify_date FROM sys.dm_db_index_usage_stats  AS DIS        RIGHT OUTER JOIN sys.indexes AS IDX  ON DIS.object_id = IDX.object_id AND DIS.index_id = IDX.index_id        JOIN sys.objects AS OBJ  ON IDX.object_id = OBJ.object_ID        JOIN sys.dm_db_partition_stats as PS ON ps.object_id = OBJ.object_id WHERE  OBJ.type IN ('U', 'V') AND DIS.object_id IS NULL GROUP BY idx.object_id ORDER BY OBJECT_NAME(IDX.object_id)