[thelist] ASP: More Selective Select

rudy r937 at interlog.com
Wed Jul 2 23:31:01 CDT 2003

> if you want to start somewhere with database : don't use plurial for
> your table names. It's part of the concept, it's THE job, THE employee
> that you aim to best describe (with your fields).


the concept is of sets of things

the set of employees, the set of jobs...

thus,   select ... from employees

casey, a more important rule than using plural names for tables is NOT to
embed the "type of the thing" into the name of the thing

for example, do not say  tblEmployees  or  colFirstname

adjective_that noun_practice verb_is adverb_really adjective_disconcerting



More information about the thelist mailing list