Re: Naming conventions for DB objects ?

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.

-- 
========================================================================
"Villains, I say to you now:       |   Mike Carmack
 KNOCK OFF ALL THAT EVIL!"         |   Vulcan Dragon -==(UDIC)==-
    S P O O N !!!!    - The Tick   |   mcarmack_at_freenet.columbus.oh.us