Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: naming conventions for constraints

Re: naming conventions for constraints

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Wed, 30 Apr 2003 15:17:58 +0200
Message-ID: <1051708308.352775@news.thyssen.com>


"Sönke Petersen" <sk.petersen_at_gmx.de> schrieb im Newsbeitrag news:b8oebc$h9h$1_at_news.mch.sbs.de...
> Additional question:
>
> do you use suffixes or prefixes?
>
> Regards,
> Sönke
>

Hi Sönke,

(apologies for taking your part, Jan! Hope you find a solution with your current problem.)
I prefer suffixes because if you have to list them of the dictionary, you have all the constraints
'ordered by table name' without explicitly doing so (well, not really a performance issue ;-)).

Greetings,
Guido Received on Wed Apr 30 2003 - 08:17:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US