[thelist] SQL - Foreign Key Constraint - in another database?
spinhead
evolt at spinhead.com
Wed Sep 5 15:55:04 CDT 2001
If you alias your table names in the queries (u.id, e.last_name, etc.) not
only does the plural/singular appearance disappear, but there's less to
type! However, if you don't alias, you've got a point I hadn't thought of
('cause I do alias.)
spinhead
----- Original Message -----
From: ".jeff" <jeff at members.evolt.org>
To: <thelist at lists.evolt.org>
Sent: Wednesday, September 05, 2001 11:13 AM
Subject: RE: [thelist] SQL - Foreign Key Constraint - in another database?
[ . . . ]
for this and other reasons i also prefer the singular naming
> schemes. it makes even more sense when you're referencing the data from a
> query.
>
> plural
> - users.id
> - employees.last_name
> - products.description
>
> or
>
> singular
> - user.id
> - employee.last_name
> - product.description
>
> the singular makes more sense to me too.
>
> thanks,
>
> .jeff
>
> http://evolt.org/
> jeff at members.evolt.org
> http://members.evolt.org/jeff/
>
More information about the thelist
mailing list