in reply to Re^2: OT: benefits of database normalization
in thread OT: benefits of database normalization

Technically, you are correct, the standard gives two lists of key words, reserved and non-reserved. It was wrong of me to say these are in the reserved list, the standard defines "NAME" and "TYPE" as non-reserved key words, not as reserved key words. However, C.J. Date, one of the authors of the standard, has this to say about non-resrved key words: "The rule by which it is determinded within the standard that one keyword needs to be reserved while another need not is not clear to this writer. In practice it is probably wise to treat all key words as reserved." A Guide to the SQL Standard, C.J. Date, p. 32.

So I apologize for over-stating that these are reserved, but stand by my advice to avoid them as identifiers unless delimited.

  • Comment on Re^3: OT: benefits of database normalization