Re: Naming conventions

Pacman wrote:
>
> I'm a junior DBA for Oracle and wondered if there are naming conventions for
> indexes, sequences, etc. With them sharing a global namespace it would be
> useful to know if there is a PDF or something out there to explain this.
>

Any naming convention is OK as long it is non-ambiguous and evident. Names of Objects must be uniwue within their schema.

We do use

- id for the PK
- pk_table for PK constraint
- fk_table_table for FKs
- ix_table_rows for indexes
- seq_table for sequences 
- tr_table_event for triggers

and so on.

U.

-- 
Uwe Schneider - WEB.DE AG  - Amalienbadstr. 41  - 76227 Karlsruhe 
F&E / Database & Software Technologies - Tel. (+49) 721 94329 8320