usually, stick with one of the following..
all lowercase, all uppercase, Or Always InterCase
or, my personal preference... lblInterCase
Have seen some that will make DB names caps, tbl names lower, and
column names lblInterCase... pick what you want, and go with it, if
you are working with others, try to match their methodology...
There really isn't a right way, I use lblIntercase for columns
dbname_TableName for tables, and dbname for the db, this is in case
I ever have to work with foreign dbs or join a project, you can tell
where something came from, and what it holds.
Keeping a UML diagram helps too...
Michael J. Ryan - tracker1[*at*]theroughnecks.com
Roughneck BBS: http://www.theroughnecks.net telnet://theroughnecks.net
Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email
One program for aim/icq/yahoo/msn/irc - http://www.trillian.cc/
"Gerard Samuel" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hope someone can confirm this.
> I was moving a mysql dump to postgresql, and I had 2 tables with MiXeD
> upper/lower case letters, that
> got converted to lowercase. I found a discussion that sql
> column/table/database names should be lowercase.
> Just trying to keep in line with a standard.
> Gerard Samuel
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php