Re: naming conventions for table/column names

From original note >>
i was wondering of someone could help me establishing naming conventions for database objects : which method to use for naming tables, columns and so on <<

Boy, do you like trouble.

My I suggest Limit table names to 23 characters or less (if symetric replication may ever be used on your system)

It will be necessary to abbreviate some words that make up part of a table name so make a list of abbreviations for common words and insist that these words always be abbreviated. This will improve table naming consistency more than you would expect at first notice.

Include the table name in the index name.

Column names should be descriptive, but should follow the table abbreviation word list rules.

Do not remove leading vowels if you like to strip the vowels and leave the constantents.

Spell checkers have ruined my writing ability so please overlook my degrading prose.   Received on Mon Feb 03 1997 - 00:00:00 CST