ORACLE 查看某个表的索引
ORACLE 中的索引
CREATE INDEX IDX_COLUMN_NAME ON TABLE_NAME(COLUMN_NAME);
ALTER TABLE TABLE_NAME ADD CONSTRAINT UK_COLUMN_NAME UNIQUE(COLUMN) ENABLE NOVALIDATE;
select * from all_indexes WHERE table_name='table_name';
SELECT
idx_col.*,
idx.index_type
FROM
user_ind_columns idx_col,
user_indexes idx
WHERE
idx_col.index_name = idx.index_name
AND idx_col.table_name = 'table_name';
SELECT
au.*,cu.position
FROM
user_cons_columns cu,
user_constraints au
WHERE
cu.constraint_name = au.constraint_name
AND cu.table_name = 'table_name';
SELECT
au.*,
cu.position
FROM
user_cons_columns cu,
user_constraints au
WHERE
cu.constraint_name = au.constraint_name
AND au.constraint_type = 'P'
AND cu.table_name = 'table_name';