Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Introducing UltraLite » UltraLite databases

 UltraLite databases Next Page

UltraLite database schema

The logical framework of the database is known as a schema. In UltraLite, the schema is maintained as a catalog of system tables that hold the metadata for the UltraLite database. Metadata stored in the system tables includes:

Schema changes with DDL statements

You can change the schema of a database with Data Definition Language (DDL) statements. A schema change can take a considerable amount of time; for example, changing the type of a column means that all rows in the associated table must be updated. Therefore, DDL statements only successfully execute when there aren't any:

If either of these conditions is true, the DDL statement fails. When the DDL statement is executing, any other attempt to use the database is blocked until the DDL statements completes the schema change.

See also