Re: Constraint Naming Conventions

From: Jason Pepper <jason_at_steamer.u-net.com>
Date: 1998/04/02
Message-ID: <6g10cv$68n$1@news.u-net.com>#1/1

Oracle's Development Methodology (Oracle Method) recommends suffixes of PK, FK, UK and a number if there is more than one. Constructed as follows..

[APP Short Name]_[Table Alias]_[Type][#]

eg. APP1_DEPT_PK
    APP1_DEPT_FK1
    APP1_DEPT_FK2 etc

--

===

Jason Pepper  Phone Mail : +44 171 691 7298
                Fax Mail : +44 171 691 7298
                  E-Mail : jason_at_steamer.u-net.com
                     WWW : www.steamer.u-net.com

Smile, fresh air is good for the teeth --

Received on Thu Apr 02 1998 - 00:00:00 CST