ALTER DATABASE SCHEMA FROM FILE filename

filename   Defines the name and path to the SQL script used to upgrade the schema of an existing UltraLite database.

Use either ulinit or ulunload to extract the DDL statements required for your script. By using these utilities, you ensure that the DDL statements are syntactically correct. Use ulinit (-l logfile option) or ulunload (using the -n -s output-file options). See UltraLite Initialize Database utility (ulinit), and UltraLite Database Unload utility (ulunload).

Backup the database before executing this statement.

The character set of the SQL script file must match the character set of the database you want to upgrade.

Ensure that your device is not reset while this statement is executing. If you reset the device during a schema upgrade, the UltraLite database becomes unusable.

Any rows that do not fit into the schema will be dropped (for instance if a uniqueness constraint is added and multiple rows contain the same values, all but one row will be dropped). In this case, the SQLE_ROW_DROPPED_DURING_SCHEMA_UPGRADE warning is generated. You can use this warning to detect the error and restore the database from the backup version.

• Deploying UltraLite schema upgrades

The following statement modifies the schema of the database using a SQL script, MySchema.sql:

ALTER DATABASE SCHEMA FROM FILE 'MySchema.sql';