>>>So, is it the consenus then that it is a bad/dangerous thing to name my Primary index "PRIMARY"?
>>
>>More than that, we also have to think ahead. Which means, a word used in code, index definition, etc., might be available to use now but may become a reserved word for upcoming versions.
>
>While your comments imply I shouldn't use the word Primary as an index name, nobody has actually said so...
>The reason I ask is because the person who trained me says he does/did it all the time.
You may go very far unharmed, but it will get you sooner or later, and the later it gets, the harder to discover. Such things are pretty hard to track, because compiler won't help you, and if it complains, it will probably give you a wrong error code. Sometimes I think that the Hungarian prefixed notation was introduced to distinguish prefixed user objects from unprefixed keywords :)