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

Home -> Community -> Usenet -> c.d.o.server -> REPOST: Re: Database Naming Conventions

REPOST: Re: Database Naming Conventions

From: Guy Dillen <gdi_at_belgacom.net>
Date: Sat, 29 Dec 2001 10:34:29 +0100
Message-ID: <9$--$$-$$_%%_%$%$$@news.noc.cabal.int>


Trifon,

Thanks for your input.

Guy

"Trifon Anguelov" <trifona_at_pacbell.net> wrote in message news:ZAdX7.17090$HH6.3934416094_at_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_at_belgacom.net> wrote in message
> news:3c2b9432$0$33504$ba620e4c_at_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
> >
> >
> >
>
>

This message was cancelled from within Mozilla...not Received on Sat Dec 29 2001 - 03:34:29 CST

Original text of this message

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