iAnywhere.com - Accessing schema information

Developing Applications Using the UltraLite C++ Component

Accessing schema information

The objects in the API represent tables, columns, indexes, and synchronization publications. Each object has a GetSchema method 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 DatabaseSchema object, use Connection.GetSchema.

For more information, see GetSchema Function.
TableSchema The number and names of the columns and indexes for this table.
To obtain a TableSchema object, use Table.GetSchema.

For more information , see GetSchema Function.
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 IndexSchema class.
To obtain a IndexSchema object, call the TableSchema.GetIndex, the TableSchema.GetOptimalIndex, or the TableSchema.GetPrimaryKey method.

For more information, see Class UltraLite_Table_iface.
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 PublicationSchema object, call the DatabaseSchema.TableSchema.GetPublicationSchema method.

For more information, see GetSchema Function.