RE: naming conventions (constraints and indexes)
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>
- To: "Joel.Patterson@xxxxxxxxxxx" <Joel.Patterson@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Nov 2011 08:56:27 -0500
Joel,
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
