RE: naming conventions (constraints and indexes)
Date: Thu, 10 Nov 2011 08:56:27 -0500
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.
TomReceived on Thu Nov 10 2011 - 07:56:27 CST