Oracle导出表结构,索引信息
select t.TABLE_NAME,
b.COMMENTS,
t.TABLESPACE_NAME,
t.PCT_FREE,
t.INI_TRANS,
t.PARTITIONED,
ui.INDEX_NAME,
ui.UNIQUENESS,
uic.COLUMN_NAME
from user_tables t,
user_tab_comments b,
user_indexes ui,
user_ind_columns uic
where t.TABLE_NAME = b.TABLE_NAME
and ui.TABLE_NAME = uic.TABLE_NAME
and ui.TABLE_NAME = t.TABLE_NAME
and ui.INDEX_NAME = uic.INDEX_NAME;