[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