To check layout and indexes

  1. You can check if there is an information mismatch between database tables and MetaData files.

    Check layout compares the database metadata with the database definition file (definition interface) and displays the mismatch if exists. The metadata from the database is retrieved from the database connection made with JDBC URL specified by db.con.url using the JDBC driver specified by the property db.con.metadatadrivername.

  2. In the Database Metadata view for a selected table, click the Layout link next to the schema name.

    If the data types match it displays OK.

    The available status are:

    • Green - OK

    • Red - mismatch

    • Yellow - invalid length

  3. Click Indexes.

    This function compares all indexes in database with the indexes in the database definition (definition interface).