Skip to main content
LinkedIn
Copied!

Table of Contents

Viewing database schema using Schema Tools

Version:

Only available versions of this content are shown in the dropdown

You can view your Pega Cloud Services database schema information for tables, columns, views, and indexes using Schema Tools. When you click any of these elements in the display, relevant information is displayed on the right side of the landing page, along with appropriate actions for updating the element in the database.

Pega Cloud Services provides Query Runner, Query Inspector, and Schema Tools in Pega Platform for clients to manage their database. These database tools are not available to on-premises clients.
  1. In the header of Dev Studio, click Configure 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.
  • Viewing the history of Schema Tools actions

    You can view the history of actions taken on a database table to see the status of an operation in Schema Tools. This information will also be reflected on the Schema Change Tracking tab.

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us