Exploring table summary

About this task

You can view list of the tables in selected database. Data table has table name, owner, and last modified date. You can search for the table in the list and table details can be found by clicking on table name link button.

Procedure

To explore the table summary:

  1. Access the console.
  2. From the navigation menu, select Admin > Database schema.
  3. Click on View link from the database list.
    Exploring table summary
    Following are the options provided on this page to view more information about the table:
    Options Additional information
    Information View general information about a table and table statistics.
    Columns View information about table columns.
    Indexes View information about table indexes.
    References View information about referential constraints.
    Privileges View information about table privileges.
    Statistics View information about table statistics and to change the options for automatically updating statistics.
    Constraints View information about table constraints.
    Fragments View information about the statistics for fragments in a fragmented table.
    Triggers View information about table triggers.