Re: Is there any recommended Naming Convention for Setting up DB Tables and Fields?

Alistair Thomson <Alistair.Thomson_at_hri.ac.uk> wrote:

>Sounds like your system administrator doesn't like typing or is too lazy
>to bother!
>
>You're right to go for descriptive names for tablespaces, tables and
>fields it makes life a lot easier for everyone who has to use the
>database. I use descriptive names and have set up scripts to run
>frequently used queries and reports for users who don't have access to
>sqlplus to run queries.

One other thing to keep in mind - try to keep table names to less than 23 characters long. Even though oracle allows 30 characters names, some of the prefixes oracle adds to tables for snapshots, snapshot logs, etc., can be up to 7 characters long.

Also, a lot of folks like to use the table name as part of constraint and index names, and constraint names are also limited to 30 characters.

One convention I've seen used is to come up with two standard names for tables: a long name which is the actual table name, and a short name used as part of constraint names, index names, etc..

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!