How to: Find out using Sql stats, whether a PK is an index/or part of a unique inde??

[Pixie22]

Im looking at the All_Indexes Table but i can only get info on indexes as a whole. and not what columns are contained within so i cannot determine if the column is an index

also im looking to find also through sql code, to what columns, certain partitions apply to? Any help is highly appreciated. Thanks

[pando]

you can try dba_ind_columns, dba_cons_columns and dba_constraints

rgds

[OracleDoc]

This will give you the column name and the order that they are being called within the table.

Select column_name, column_position,descend, table_name
from    sys.DBA_IND_COLUMNS
where   index_owner = &a
and     index_name  = &b

This will tell you what columns are patitioned in a table.

Select COLUMN_NAME, COLUMN_POSITION 
FROM 
sys.DBA_PART_KEY_COLUMNS 
WHERE name=&tablename'
and owner='&shcemaname'
ORDER BY NAME, COLUMN_POSITION

Hope this helps.

[Pixie22]

cool Thanks. that helps alot!