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.
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.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |