SQL Server查询表索引情况脚本
--/*将红色字体部分替换成要查询的表名即可*/
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';
SQL Server查询表索引情况脚本
--/*将红色字体部分替换成要查询的表名即可*/select A.SCHEMANAME,A.TABLENAME,A.INDEXNAME,A.TABLESPACE,A.INDEXDEF,B.AMNAME,C.INDEXREL...
点击下载文档
本文2024-09-16 22:37:47发表“eas cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-eas-49340.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章