UltraLite Database User's Guide
Utility Programs
The database schema is the database without the data. It is the collection of tables, indexes, and so on within the database, and all the relationships between them. The schema file stores schema information. You do not alter the schema of an UltraLite database directly. Instead, you modify a schema file (which typically has the extension .usm) and upgrade the database schema from that file using a built-in UltraLite function in your application.
You can create an UltraLite schema file in the following ways:
Generate the schema from an Adaptive Server Anywhere database If you have the Adaptive Server Anywhere database management system, you can generate an UltraLite schema file using the ulinit command line utility.
UltraLite Schema Painter The UltraLite Schema Painter is a graphical utility for creating and editing UltraLite schema files.
To start the Schema Painter, choose Start
The ulxml command line utility The ulxml command line utility allows you to open usm files and save them to XML format, open XML files and save them as usm files, and to export XML files to a format suitable for Palm. For more information, see The ULXML utility.