Re: Database Naming Conventions

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
>
>
>
Received on Sat Dec 29 2001 - 00:42:01 CST