Counting the rows in a database table

You can use any software that allows read-only access to the database (such as Oracle SQL Plus) to count the rows in a table. This information is useful for tablespace planning. In addition, you can use the System Management application to summarize rows in a table by class.

Each concrete class mapped to the table that contains one or more saved instances (rows) is displayed along with the count for each.

  1. Select Designer Studio > System > Operations > System Management App to start the System Management application.
  2. Select any node.
  3. Click Advanced > Database Table Information.
  4. Click the button corresponding to the table for which you want to know the number of rows.
  5. Click List Record Count.