UltraLite for MobileVB User's Guide
Understanding UltraLite for MobileVB Development
Objects in the API represent tables, columns, indexes, result sets, and synchronization publications. Each object has a Schema property that provides access to information about the structure of that object.
Here is a summary of the information you can access through the Schema objects.
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, call the ULConnection.Schema property.
ULTableSchema The number and names of the columns and indexes for this table.
To obtain a ULTableSchema object, call the ULTable.Schema property.
ULColumnSchema The SQL data type, default value, and other characteristics of the column, such as whether it accepts NULL.
To obtain a ULTableSchema object, call the ULColumn.Schema property.
ULIndexSchema Information about the type of index and the columns in it. As an index has no data directly associated with it (only that which is in the columns of the index) there is no separate ULIndex object, just a ULIndexSchema object.
To obtain a ULIndexSchema object, call the ULTableSchema.GetIndex method.
ULPublicationSchema Tables contained in a publication. Publications are also comprised of schema only, and so there is a ULPublicationSchema object rather than a ULPublication object.
To obtain a ULPublicationSchema object, call the ULDatabaseSchema.GetPublicationSchema method.
ULResultSetSchema The number and names of the columns in a result set.
You cannot modify the schema through the API. You can only retrieve information about the schema. For information about modifying the schema, see Altering the schema of UltraLite databases.