Selecting Tables

Use the Query Builder - Tables page to select tables that will contain the report data.

SQR Production Reporting Studio organizes tables under schemas.

*  To select tables:

  1. Select which tables and views to display.

    Click the arrow to the right of the list box under Available Tables.

    You can Show Tables; Show Tables and Views; Show Tables, Views, and System Tables; or Show All. (Show All displays all the items in the database, including custom tables and aliases.)

    A View is a stored result set from a query. System Tables are hidden or private tables; they generally contain information about the database.

  2. Select the desired tables.

    • Drag the table into the right pane.

    • Select a table and click Right Arrow button.

Note:

Expand a table to view its columns and data types. To expand a table, click the plus sign (+) next to the table, or double-click the table.

Related Topics

Finding Database Objects

Defining Table Aliases

Joining Tables