SQL Server查询表索引情况脚本原创
2人赞赏了该文章
268次浏览
编辑于2021年10月14日 11:06:13
--/*将红色字体部分替换成要查询的表名即可*/
select A.SCHEMANAME,A.TABLENAME,A.INDEXNAME,A.TABLESPACE,A.INDEXDEF,B.AMNAME,C.INDEXRELID,C.INDNATTS,C.INDISUNIQUE,C.INDISPRIMARY,C.INDISCLUSTERED,D.DESCRIPTION
from PG_AM B left join PG_CLASS F on B.OID = F.RELAM
left join PG_STAT_ALL_INDEXES E on F.OID = E.INDEXRELID
left join PG_INDEX C on E.INDEXRELID = C.INDEXRELID
left outer join PG_DESCRIPTION D on C.INDEXRELID = D.OBJOID,PG_INDEXES A
where A.SCHEMANAME = E.SCHEMANAME and A.TABLENAME = E.RELNAME and A.INDEXNAME = E.INDEXRELNAME
--and E.SCHEMANAME = 'public'
and E.RELNAME = 't_fdc_costaccount';
推荐阅读