View tables and table structures

Open Object Explorer.

Select a connected OLEDB data source and double-click it to expand to the Catalog views folder.

For more information, see Catalog views.

Double-click the Catalogs folder to expand to the schema folders.

Note: By default, the data model for PI SQL Client consists of one catalog - Master. This catalog contains a set of tables and table-valued functions.

For information about how to create other catalogs, see Use the template-specific data model wizard.

Double-click a schema folder to expand to the Tables folder to view objects that represent tables, and the following within each table:

• Primary key columns

  Primary key columns are preceded by a key icon in schemas within an OLEDB or ODBC data source.

• Columns

  Table columns that are not primary keys are preceded by a table icon.

• Data types

  Data types for each primary key column or column within a table are displayed in parentheses next to the (primary key) column names.

  

  • 1 - Primary key columns

  • 2 - Columns

  • 3 - Data types