Accessing schema information

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.