You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by Joachim Müller <jo...@wemove.com> on 2006/01/16 18:27:01 UTC

database table and field naming conventions

Hi.

Is there a reason that all table names and column names are written in
capital letters?

Does something speak against defining new tables in lower case?
(database dependencies, etc.)


Best Regards.

Joachim


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Re: database table and field naming conventions

Posted by Jacek Wiślicki <ja...@gmail.com>.
Wiadomosc od Randy Watler z 2006-01-16 19:17 brzmiala:

> Just convention AFAIK. Lengths need to be less than 30 chars for Oracle.
Anyway, SQL is case-insensitive. At least according to the specification...

-- 
pozdrawiam,
     Jacek Wislicki

jacek.wislicki@gmail.com
tel.: +48 502 408 444
gg: 2540358
skype: jacek_wislicki

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


Re: database table and field naming conventions

Posted by Randy Watler <wa...@wispertel.net>.
Just convention AFAIK. Lengths need to be less than 30 chars for Oracle.

Randy

On Mon, 2006-01-16 at 18:27 +0100, Joachim Müller wrote:
> Hi.
> 
> Is there a reason that all table names and column names are written in
> capital letters?
> 
> Does something speak against defining new tables in lower case?
> (database dependencies, etc.)
> 
> 
> Best Regards.
> 
> Joachim
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org