RE: naming conventions (constraints and indexes)

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Thu, 10 Nov 2011 08:56:27 -0500
Message-ID: <AD4532B304E00C4F9AEFA0D338DF7DD1067A6DB1F4_at_excnysm95banp.nysemail.nyenet>


I name constraints and indexes like this:

Constraint	Index
   Name	Name
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.


Received on Thu Nov 10 2011 - 07:56:27 CST

Original text of this message