Table Creation and Alter Scripts

Creation scripts contain SQL commands to create stored procedures and tables and their columns.

Alter scripts contain SQL commands to modify an existing stored procedure, table, or column so that it matches changes that have been made to the JADE classes, properties, column-mapping methods, and so on, to keep the target RDBMS database consistent with the JADE database. A generated alter script contains the SQL DDL commands required to modify existing tables, columns, and stored procedures that bring into effect the changes that were made in the RPS mapping or mapped classes in the primary database. (For details, see "Alter Scripts" under "Schema Instantiation", later in this chapter.)

For details about generating creation and alter scripts, see "Generating Table Creation SQL Scripts" and "Generating Table Alter SQL Scripts", later in this chapter, or the RelationalView class generateRpsTableCreationScript method in Volume 2 of the JADE Encyclopaedia of Classes.