Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
reserved names? |
Fri, Jul 24 2009 3:24 PM | Permanent Link |
"Lucian Radulescu" | Hi,
I am upgrading an application (kind of source safe app) and some of the tables are named like this: USERS, PROJECTS, FILES, HISTORY, LABELS. Any worries? TIA, Lucian |
Sat, Jul 25 2009 3:46 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Lucian
Apart from getting yourself confused you mean The system tables are in a different database so they won't be interfered with by yours. However, to stop confusing yourself I suggest you try and avoid using names that are used for the system files eg I renamed my Users table to Staff. Roy Lambert [Team Elevate] |
Sun, Jul 26 2009 4:53 PM | Permanent Link |
"Lucian Radulescu" | > so they won't be interfered with
I heard stuff like this before I hope it really stays like that. > avoid using names that are used for the system files eg I renamed my > Users table to Staff. Funny thing, at the office we have a table called "setup" for users. I dislike that and for my own apps I don't actually want to call "Users" anything else than "Users", because it's actually storing users (not staff like in your case, maybe). I'd rather like the system tables being called in such a manner so that they'll never interfere with my stuff, for example "$sys$_users" ... but I guess it's too late for that now . -- Thanks, Lucian |
Mon, Jul 27 2009 4:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Lucian,
<< I am upgrading an application (kind of source safe app) and some of the tables are named like this: USERS, PROJECTS, FILES, HISTORY, LABELS. >> No. The SQL parsing is always contextual and related to the current database, so you shouldn't have any problem naming the tables anything that you want. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jul 28 2009 8:16 PM | Permanent Link |
"Lucian Radulescu" | > No. The SQL parsing is always contextual and related to the current
> database, so you shouldn't have any problem naming the tables > anything that you want. Allrightieeee! -- Thx, Lucian |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |