暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
table_index
emcs
37次下载
590次浏览
2019-07-24
4.5

脚本内容

--查看表的索引 select col.table_owner "table_owner", idx.table_name "table_name", col.index_owner "index_owner", idx.index_name "index_name", uniqueness "uniqueness", status, column_name "column_name", column_position from dba_ind_columns col, dba_indexes idx where col.index_name = idx.index_name and col.table_name = idx.table_name and col.table_owner = idx.table_owner and col.table_owner='&owner' and col.table_name='&table_name') order by idx.table_type, idx.table_name, idx.index_name, col.table_owner, column_position;

评论

贡献排行榜