6. Considerations for OpenVMS : Schema Checking
 
Share this page                  
Schema Checking
Ingres reserves a number of new keywords, mostly for support of SQL additions. If names such as substring, first, or cache are used as column names, you must change the database schema. For a list of Ingres reserved words, see the appendix “Keywords” and the SQL Reference Guide.
If you are concerned that some column names in your database may conflict with reserved words, you can take a copy of the schema from the current installation and load it into an Ingres database. You should extend these checks to the applications to verify that tables and views created at runtime are not affected by the new keywords. Conflicts found in the schema and applications must be removed before moving to Ingres.