UltraLite for M-Business Anywhere User's Guide
Understanding UltraLite for M-Business Anywhere Development
Each Connection, ULTable, and ResultSet object contains a schema property. These schema objects provide information about the tables, columns, indexes, and publications in a database.
For information about modifying the schema, see Changing the schema of a database.
DatabaseSchema 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, access the Connection.databaseSchema property.
TableSchema The number and names of columns in the table, as well as the Indexes collections for the table.
To obtain a TableSchema object, access the ULTable.schema property.
IndexSchema Information about the column, or columns, in the index. As an index has no data directly associated with it, there is no separate Index object, only a IndexSchema object.
The IndexSchema objects are accessed using the TableSchema.getIndex method.
PublicationSchema The numbers and names of tables and columns contained in a publication. Publications are also comprised of schema only, so there is a PublicationSchema object but no Publication object.
The PublicationSchema objects are accessible using the DatabaseSchema.getPublicationSchema method.
ResultSetSchema The number and names of the columns in a result set.
The ResultSetSchema objects are accessible using the PreparedStatement.getResultSetSchema method or the ResultSet.schema property.
SQL Anywhere Studio 9.0.2
版权所有 © 1989–2005 Sybase, Inc. 部分版权所有 © 2001–2005 iAnywhere Solutions, Inc. 保留所有权利。