Re: Constraint Naming Conventions

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: 1998/04/01
Message-ID: <3522E691.22619C5B@access-laserpress.com>#1/1

I tend to use these codes as suffixes, otherwise it's difficult to find all the constraints associated with a given table in a concise manner. So I use:

PK - Primary Key
FK - Foreign Key (references)
UN - Unique
NN - Not Null
CK - Check

Clive Walden wrote:
>
> Are there any generally accepted naming conventiond for Constraints.
>
> I intend to use PK, FK, IX etc to describe Primary Keys, Foreign Keys
> etc. However, I have seen two books with different conveentions.
>
> One uses PK etc. as a prefix the other as a suffix.
>
> Book 1.
>
> xxxxx_PK
>
> the other
>
> PK_xxxxxx
>
> Presumably one makes it easy to group constraints by type, the other
> by Object.
>
> Thanks - Clive
Received on Wed Apr 01 1998 - 00:00:00 CST