Re: Naming conventions for DB objects ?

From: Carl Van de Casteele <cvandecasteele_at_tis.be>
Date: 1997/03/04
Message-ID: <331c0157.12405195@news.innet.be>#1/1

On 19 Feb 1997 13:30:36 -0500, mcarmack_at_freenet.columbus.oh.us (Michael Carmack) wrote:

>Michael Agbaglo (michael_at_isv-gmbh.de) wrote:
>: Are there any naming conventions for tables, views, procedures,... ?
>
>That is most certainly determined by the organization, i.e the DBA and
>senior programmers should work together to determine a naming convention
>that everyone will be happy with.
>
>My personal opinion is that a table, view, etc. should simply describe
>the data it holds, e.g. a table with information on employees should
>simply be named EMPLOYEES. Avoid Hungarian notation (e.g. TBLEMPLOYEES)
>for database objects.
>--

I think that a tablename should always be singular so EMPLOYEE instead of 'employees'.

Carl Van de Casteele
E&Y Consulting Received on Tue Mar 04 1997 - 00:00:00 CST