查看表索引的详细信息

SELECT T2.NAME,T3.NAME,OBJECT_NAME(T1.object_id),T1.* FROM sys.dm_db_index_physical_stats(NULL,NULL,NULL,NULL,NULL) T1
								INNER JOIN SYS.databases T2 ON T1.database_id = T2.database_id
								AND T1.database_id >4
								INNER JOIN SYS.objects T3 ON T1.object_id = T3.object_id
								AND T3.type=N'U'
								ORDER BY T1.index_depth DESC