用sql语句如何查询某一列是否建立了索引

[df978]

如题,在sqlserver中可以查询,在oracle中怎样查询呢?

[沝林]

SQL> select count(*) from dba_ind_columns where table_name = 'A' and column_name = 'ID';

COUNT(*)
----------
0

SQL> create index AAA on A (ID);

Index created

SQL> select * from dba_ind_columns where table_name = 'A' and column_name = 'ID';

Index Owner Index Name Table Owner Table Name Column Name Column Position Column Length Char Length Descend
---------- -------- ------- ----- ----- ------ ------ ----- ---------
DZL AAA DZL A ID 1 22 0 ASC

[feng2]

SQL> select count(0) from user_ind_columns where table_name = 'A' and column_name = 'Col1';

COUNT(0)
----------
0

Executed in 0.016 seconds

SQL>

表示表A的字段Col1没有索引。

[df978]

谢谢