Its often personal. My preference (over 10 years of db design, and DBA) is
to use simple names with no table or type extensions.Therefore au_user
becomes user, au_salary becomes salary.
The main reason for simple naming is that end-users frequently see table and
field names and they tend to find extended naming structures confusing.
The most important thing is to be completely consistent ;-)
Hungarian (including type in name) can be more useful in programming but
even that is debatable with modern IDE's and debugging tools (IMHO)
Julian
<Jo*********@gmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Hi,
I am learning Ms Sql and I found that a lot of the tables I am finding
( in different tutorials ) are using special names for their column
names such like au_username, au_salery ...
Is the any naming convention for column names, or just at all is there
any reason for naming the table columns in specific way.
Thanks in advance.