Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: naming conventions for constraints
We use suffixes and the table name only. If we tried to use the column name
as well we'd have many cases where the constraint name would end up being
longer than 30 characters.
"Sönke Petersen" <sk.petersen_at_gmx.de> wrote in message
news:b8odom$f2d$1_at_news.mch.sbs.de...
> Hello,
>
> after studying some documents on naming conventions the main
recommendations
> for constraints seem to be that constraints should be named as the table
it
> is applied to, followed by a suffix which identifies its type.
>
> table name: systems
>
> possible constraint names could be:
>
> systems_pk --> primary key constraint
> systems_fk --> first foreign key constraint
> systems_fk2 --> second foreign key constraint
>
> A second approach could be to apply the column name as well:
>
> systems_id_pk --> primary key constraint
> systems_hostname_fk --> foreign key constraint
>
> What are your opinions?
>
> Sönke
>
>
Received on Wed Apr 30 2003 - 16:40:02 CDT