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, and the 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, and 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 include the PublicationSchema object, but not the 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.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |