Reserved words

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

Transact-SQL does not allow 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.

Before performing the upgrade, use sp_renamedb to change the name of any user database that is a reserved word.

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.

Running a reserved word check

Run the reserved word check on the old Adaptive Server:

Install the Cluster Edition version of installupgrade (where $SYBASE and $SYBASE_ASE are the values for the Cluster Edition):
```
isql -Usa -Ppassword -Sserver_name 
  -i$SYBASE/$SYBASE_ASE/scripts/installupgrade
```

Install the Cluster Edition version of usage.sql:

isql -Usa -Ppassword -Sserver_name 
   -i$SYBASE/$SYBASE_ASE/upgrade/usage.sql

Log in to the old Adaptive Server and execute sp_checkreswords on all the databases. For example:
```
use sybsystemprocs
go
sp_checkreswords
go
```
Correct any errors from the reserved word check.