Eliminate reserved words from your database prior to migration or upgrade by either changing them to something other than reserved words or enclosing them in quotation marks where possible.
- To eliminate the reserved words, do one of the following:
- Change the word to something else. For example, change reserved word FUNCTION to THEFUNCTION.
- For some uses, such as in column names, you can enclose the reserved word in quotes to prevent the database from interpreting it as a reserved word. For example, change reserved word FUNCTION to "FUNCTION".
The Reserved Words script may not find all instances of the reserved words, because Client databases are not checked and the names can be obscured through aliases and embedded SQL statements.