Viewing Properties of Minischema Tables, Relational Source Tables and User-Defined Tables

  To view the properties of a minischema table, relational source table, or user-defined table:

1. From the Source Navigator, select the Minischema tab or the Data Sources tab.

2. Under Minischemas or Data Sources in the physical tree, navigate to the minischema table, relational source table, or user-defined table whose properties you want to view.

3. Right-click the table and select Properties to view the General properties.

   These properties are displayed:

   • Physical source table name

   • Data source connection name

   • Primary keys, if any

   • Comment

   To view the column properties of the table, click the Column tab. See Viewing Properties of Minischema Columns, Relational Source Columns, and User-Defined Table Columns. Also see Viewing the Statement on Which a User-Defined Table is Based.

4. Optional: If you are viewing properties of a minischema table from a minischema diagram, enter a Comment.

   Note:

   The Comment field is not available when viewing properties of relational tables or user-defined tables.