Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news.maxwell.syr.edu!skynet.be!skynet.be!louie!not-for-mail
From: "Guy Dillen" <gdi@belgacom.net>
Newsgroups: comp.databases.oracle.server
References: <3c2b9432$0$33504$ba620e4c@news.skynet.be> <ZAdX7.17090$HH6.3934416094@newssvr14.news.prodigy.com>
Subject: Re: Database Naming Conventions
Date: Sat, 29 Dec 2001 10:34:29 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Lines: 53
Message-ID: <3c2d8d7f$0$56403$ba620e4c@news.skynet.be>
Organization: -= Skynet Usenet Service =-
NNTP-Posting-Host: 217.136.98.153
X-Trace: 1009618303 reader0.news.skynet.be 56403 217.136.98.153
X-Complaints-To: abuse@skynet.be
Xref: easynews comp.databases.oracle.server:129040
X-Received-Date: Sat, 29 Dec 2001 07:20:17 MST (news.easynews.com)

Trifon,

Thanks for your input.

Guy


"Trifon Anguelov" <trifona@pacbell.net> wrote in message
news:ZAdX7.17090$HH6.3934416094@newssvr14.news.prodigy.com...
> Guy,
>
> I have seen people using:
>
> Name_SEQ for sequences;
> Name_IDX for indexes;
>
> Primary key columns are (ID) and foreign keys columns
> (referenced_table_name_ID);
>
> Primary key constraints - (table_name_PK)
> Unique key constraints - (table_name_UK)
> Foreigh key constraints - (table_name_FK)
>
> For table columns use if possible full column description (no
abreviations)
>
> Hope that helps.
>
> Trifon Anguelov
> Senior Oracle DBA
>
> http://www.dbaclick.com
>
>
>
> "Guy Dillen" <gdi@belgacom.net> wrote in message
> news:3c2b9432$0$33504$ba620e4c@news.skynet.be...
> > Are there any naming conventions for Oracle
> > database objects (table names, column names, indexes, keys, stored
> > procedures, ...)
> >
> > All input very much appreciated.
> >
> > Thanks.
> >
> > Guy
> >
> >
> >
>
>