Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Naming conventions for Table Fields
In my reading I came across a convention for namining fields in a table that used a 2 letter table identifier followd by an underbar as a prefix to all table field names.
For example in a Customer table une would finf fields:
cu_CustCode
cu_Address
cu_City
cu_State
etc. Each table had its fields specified in this manner.
It is clear that there are advantages to this nomenclature in that you can easily identify and distinguish a field in a table from memory variable. There are also advantages in SQL statements.
Doing it however is somewhat of a pain and I am wondering if it is worth the effort.
Does anyone have any experience in using this naming approach?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement