August 23, 2003 at 9:41 am
If Table is a reserved keyword then why does EM default to Table1 name when creating a table?
Programmers argue this point in order to use the word table in their names since this is the example SQL pops up for them?
August 23, 2003 at 9:46 am
you can use any word in your name generally including table you may need to qualify it with
to use it properly.
Wes
August 24, 2003 at 8:16 pm
EM defaults to Table1 due to legacy naming conventions from prior MS products. IE Access. When you create a 1st instance it is object1 then 2 (after checking to see the highest # created) and so forth. This way the developers ensured that the new objects would be able to be created without naming conflicts and potential crashes in the system.
If the people in your company want to use "table" they will have to qualify the name with additional information anyway. This is another case of how does this shop do things vs another shop I think.
Good luck fighting the naming war
AJ Ahrens
SQL DBA
Revenue Assurance Management - AT&T
Good Hunting!
AJ Ahrens
webmaster@kritter.net
August 25, 2003 at 5:41 am
hi!
read carefully: "table" is a reserved word ... "table1" isn't! 😉
best regards,
chris.
August 25, 2003 at 7:49 pm
I did read carefully, table1 is not the same as table. table1 is an object. Not needing delimiters and then needing delimiters. whoteegan explained more on the legacy side which is what helped me understand why. For me, if you have to say table somewhere use an alias.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply