Abbreviate Oracle Table Names?

Hi

You are correct that , very cryptic naming conventions shouldn't be encouraged. And also the old trend.

Having longer names are the new trend (every where ) , for example take a trigger name WHEN-NEW-FORM-INSTANCE etc.

Well

In my assignment the standard what we follow are as follows.

We have around 300 tables at present.

1. Table names will have a max of 20 char long.
   ( because oracle allows a max of 30 chars object size )
   
2. remove the vowels from entity name and make a self-descriptive name. Max 20 chars.
   (examples
   

          entity name                   table name
          -----------                   -----------
          Works Orders                  Works_orders
          employees                     employees
          Card Material Requirements    card_Material_reqmts
          
     in general we try to give the same name as the entity if it is 
     less than or equal to 20 chars.

        ) 
     3. Always a table name is pluralised.
        exceptions are like say STOCK_MASTER.

     4. For better readability we use '_' (underscore) appropriately.

     
     5. COLUMN NAMES : 
 
        max 25 characters long.


     6. Constraint names : xx-<table name>_#

This approach has helped us a lot and makes lot more sense too.

There are many more. Please drop a mail , should u require anr clarification

Regards
N.Elangovan
engsys_at_singnet.com.sg Received on Thu Dec 21 1995 - 00:00:00 CET