|
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. |
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 accessed using the ULTableSchema.GetIndex method.
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 accessible using the ULDatabaseSchema.GetPublicationSchema method.
ULResultSetSchema The number and names of the columns in a result set.
The ULResultSetSchema objects are accessible using the ULPreparedStatement.ResultSetSchema property.