RE: naming conventions (constraints and indexes)

I name constraints and indexes like this:

Constraint	Index
   Name	Name
Table_PK	TABLE_PK
Table_FK01	Table_K01
Table_FK02	Table_K02
Table_FK03	Table_K03

Additional Indexes are named Table_Knnn. Check Constraints are named Table_Cnn.

This way I can see clearly that each FK is supported by an index.

So I think you and I do something similar. An easy way to relate Constraints and Indexes.

Tom

--
http://www.freelists.org/webpage/oracle-l