--找出所有非xml索引DECLARE cur CURSOR FORSELECT[object_name]=s.name '.' OBJECT_NAME(A.object_id),B.nameFROM sys.dm_db_index_physical_stats(DB_ID('Adve......
--找出所有非xml索引
DECLARE cur CURSOR FOR
SELECT
[object_name]=s.name '.' OBJECT_NAME(A.object_id),
B.name
FROM sys.dm_db_index_physical_stats(DB_ID('AdventureWorks'),NULL,null,null,null) AS A
JOIN sys.indexes AS B
ON A.[object_id]=B.[object_id]
1/4 1 2 3 4 下一页 尾页 |
