UltraLite ActiveX User's Guide
Understanding UltraLite ActiveX Development
Each ULConnection, ULTable, and ULColumn object contains a schema property. These schema objects provide information about the tables, columns, indexes, and publications in a database.
NoteYou cannot modify the schema through the API. You can only retrieve information about the schema.For information about modifying the schema, see Creating UltraLite database schema files. |
ULDatabaseSchema 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 the ULConnection.Schema property.
ULTableSchema The number and names of columns in the table, as well as the Indexes collections for the table.
To obtain a ULTableSchema object, access the ULTable.Schema property.
ULColumnSchema Information about an individual column, including its default value, name, and whether it is autoincrement.
To obtain a ULColumnSchema object, access the ULColumn.Schema property.
ULIndexSchema Information about the column, or columns, in the index. As an index has no data directly associated with it, there is no separate ULIndex object, only a ULIndexSchema object.
The ULIndexSchema objects are available as part of the ULTableSchema.Indexes collection.
ULPublicationSchema The numbers and names of tables and columns contained in a publication. Publications are also comprised of schema only, so there is a ULPublicationSchema object but no ULPublication object.
The ULPublicationSchema objects are available as part of the ULDatabaseSchema.Publications collection.