Schema information access

You can programmatically retrieve database schema descriptions. These descriptions are known as schema information and are accessible using system tables and the UltraLiteJ API schema interfaces.

Accessing schema information using system tables

Accessing schema information using schema interfaces

Some schema information can be accessed using schema interfaces instead of system tables. The UltraLiteJ API contains the following schema interfaces:

TableSchema Returns information about the column and index configurations.
IndexSchema Returns information about the columns in the index. IndexSchema objects can be retrieved from TableSchema objects.
ColumnSchema Returns information about the columns in the table. ColumnSchema objects can be retrieved from TableSchema objects.

Schema information access

Accessing schema information using system tables

Accessing schema information using schema interfaces

See also