The objects in the table 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.
You can access the following schema objects and information:
ULDatabaseSchema Exposes the number and names of the tables in the database, and the global properties such as the format of dates and times.
Call ULConnection.Schema to obtain a ULDatabaseSchema object. See Schema property and ULDatabaseSchema class.
ULTableSchema The number and names of the columns and indexes for this table.
Call ULTable.Schema to obtain a ULTableSchema object. See Schema property and ULTableSchema class.
ULIndexSchema 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.
Call the ULTableSchema.GetIndex, ULTableSchema.GetOptimalIndex, or ULTableSchema.GetPrimaryKey method to obtain a ULIndexSchema object. See ULTableSchema class and ULIndexSchema class.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |