Reserved Words

Reserved words are pieces of SQL syntax that have special meaning when used as part of a command.

Transact-SQL disallows words that are part of command syntax to be used as identifiers, unless they are enclosed in quotation marks. If you are upgrading Adaptive Server, and the identifiers in your user databases match new reserved words, errors can result when you run queries, stored procedures, or applications that use these identifiers.

Conflicts between object names do not prevent the upgrade process from completing. However, applications that refer to conflicting object names may not work after the upgrade.

If you change an object name, change applications and stored procedures that refer to that object.

See the Reference Manual:Building Blocks for a complete list of reserved words.

• Addressing Reserved Words Conflicts
  Use sp_dboption to set the database to single-user mode, and then run sp_renamedb, specifying the new name.
• Using Quoted Identifiers
  To avoid reserved word conflicts, all users on the server must invoke the quoted_identifier option in all stored procedures and queries that include the reserved words.
• Running a Reserved Word Check
  Run the reserved word check on the old Adaptive Server.