UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

Pluralization of database table names	by SnappingTurtle	2005-09-12 02:00:41
do what you like, but be consistent	by kingdom	2005-09-12 02:41:45
Ugh.	by LionsPhil	2005-09-12 02:51:36
it's not for the "ugh" alone	by kingdom	2005-09-12 03:32:55
Hm I think often they are but as usual I would not count on it. Anyway types are not the only source of possible naming-conflicts. Try to make a Table called Join, Order, Union or something. OK, it is not often that those conflicts occur but better safe than sorry. The thing is especially DBMS' have often a huge pile of reserved words and terms and imho you can not be careful enough with it. I even saw DBs where every name had an identifier of its kind before the name, like tbl_<tablename> for tables, vw_<viewname, prz_procedure. The other way to almost certainly avoid conflicts is to add a project-specific tag before any name. Like for a project called "userfriendly" a table would be called UF_<tablename>
[ Reply ]
It's not in MySQL, I can tell you that.	by LionsPhil	2005-09-12 04:03:41

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)