Viewing database schema information

You can view database schema information for tables, columns, views, and indexes. When any of these elements are clicked in the display, relevant information about that element is displayed on the right side of the landing page, along with appropriate actions for updating the element in the database.

  1. Click Designer Studio > System > Database > Schema Tools.
  2. Expand the database schema tree and select the element that you want to view. The following information is displayed in the right panel for each type of element:
    • Tables - History of actions performed, estimated number of rows in the table, time since the last statistics were collected, and the number of rows by class
    • Columns - Table name, data type, and width, if available, and average and maximum BLOB size for columns that have a data type of BLOB
    • Views - View definition
    • Index - Table name, type, and ordered list of index components. Index components consist of either database columns or functions. The primary key is indicated by an icon next to the name.