Thank you,
we are trying to create a naming convention for the indexes within our
database, when you create a primary key it automatically creates an index on
the system.. is it possible to specify the index name when creating a
primary key?
Marc Mazerolle wrote in message <378257DE.A5E9E878_at_sympatico.ca>...
>Try the all_ind_columns for columns of the indexes and all_tab_columns for
>columns of the tables.
>
>Noah Arliss wrote:
>
>> Is there anyway to get the complete index information, including the keys
>> that the index was created on out of the oracle database?
>>
>> the all_indexes table for gives me table name, owner, and index info, but
>> not the keys the index exists on.. I need that info..
>>
>> Noah
>
Received on Tue Jul 06 1999 - 15:28:08 CDT
