Re: Naming conventions for DB objects ?

I agree that it is best to keep the table names sigular, and to 23 characters or less. This is to allow the use of symmetric replication at a future date without undue difficulity. Also since some tables will need some portions of their name abbreviated the words that will need to be abbreviated in several tables should be abbreviated in all table names.

Example 'hist' for 'history'

    order_history ==> order_hist and since order may well need to be chopped

    order_history ==> ord_hist

This type of rule help make the entore application consistent! When abbreviating words do not just chop out the vowels. Words that start with a vowel probably still need to start with a vowel to be easy to recognize.

Just opinions based on working with huge, inconsistent systems.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Mar 04 1997 - 00:00:00 CST