iAnywhere.com - Accessing schema information

Accessing schema information

The objects in the API represent tables, columns, indexes, and synchronization publications. Each object has a Schema property that provides access to information about the structure of that object.

You cannot modify the schema through the API. You can only retrieve information about the schema.

For information about modifying the schema, see Upgrading your database schema.

You can access the following schema objects and information.

DatabaseSchema exposes the number and names of the tables in the database, as well as global properties such as the format of dates and times.
To obtain a ULDatabaseSchema object, access ULConnection.Schema (iAnywhere.Data.UltraLite namespace) or Connection.Schema (iAnywhere.UltraLite namespace).

For more information, see ULConnection class (iAnywhere.Data.UltraLite namespace) or Connection class (iAnywhere.UltraLite namespace).
TableSchema The number and names of the columns and indexes for this table.
To obtain a ULTableSchema object, access ULTable.Schema (iAnywhere.Data.UltraLite namespace) or Table.Schema (iAnywhere.UltraLite namespace).
IndexSchema Information about the column in the index. As an index has no data directly associated with it there is no separate Index class, just a ULIndexSchema class.
To obtain a ULIndexSchema object, call the ULTableSchema.GetIndex, the ULTableSchema.GetOptimalIndex, or the ULTableSchema.GetPrimaryKey method.
PublicationSchema A list of the tables and columns contained in a publication. Publications are also comprised of schema only, and so there is no Publication object.
To obtain a ULPublicationSchema object, call the ULDatabaseSchema.GetPublicationSchema method.

For more information, see ULTableSchema class (iAnywhere.Data.UltraLite namespace) or TableSchema class (iAnywhere.UltraLite namespace).