[thelist] SQL - Foreign Key Constraint - in another database?

.jeff jeff at members.evolt.org
Wed Sep 5 15:59:48 CDT 2001


joel,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: spinhead
>
> 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!
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

there's also more for to figure out next time someone has to work on it.

alias as a last resort.  name your tables and columns with descriptive names
that follow some sort of pattern from the beginning and everybody will be
happier.

thanks,

.jeff

http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/






More information about the thelist mailing list