Re: Archaic Table Names. Frowned upon Synonyms
Date: 1998/03/15
Message-ID: <6efci9$l9l_at_bgtnsc02.worldnet.att.net>#1/1
On Fri, 13 Mar 1998 22:13:18 +0100, "Adrian Hodson" <NoJunk_at_email.please> wrote:
>At the bank where I work a typical table name is called TPF47 or PFM16 and
>synonyms are frowned upon - they are said to make debugging of problems more
>difficult!!!!!!!
>
>Reasoned argument has had no effect on the DB2 administrators that admin
>Oracle as a side line.
Maybe you could convince them to combine the two approaches, for example:
TPF47_CUSTOMER_ACCOUNT_HISTORY On the systems that I maintain, all the table names have a unique three letter code followed by a more descriptive table name. All field names in each table are then prefaced by the table's three letter abbreviation. The whole reason this was originally done was so the developers didn't have to qualify fieldnames in a query. However, I've found that it does make it easier to consistantly name foreign keys, indexes, and the like.
Jonathan Received on Sun Mar 15 1998 - 00:00:00 CET