Re: Constraint Naming Conventions

From: David Sisk <davesisk_at_ipass.net>
Date: 1998/04/02
Message-ID: <m2CU.71$Tf3.1782613@news.ipass.net>#1/1

Hi:

I prefer using them as suffixes myself, but it really doesn't matter. Any info that you need to find on constraints can be gleaned from the data dictionary (DBA_CONSTRAINTS and DBA_CONS_COLUMNS).

Good luck,
Dave

Clive Walden wrote in message <3522c02b.4568962_at_news1.abac.com>...
>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 Thu Apr 02 1998 - 00:00:00 CST