Viewing Properties of Relational Source Tables and User-Defined Tables

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

  1. In the Data Source Navigator, under Data Sources in the physical tree, expand the appropriate data source connection, and then navigate to the relational source table or user-defined table whose properties you want to view.

  2. 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 Relational Source Columns and User-Defined Table Columns. Also see Viewing the Statement on Which a User-Defined Table is Based.

  3. 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.

To view the properties of tables and columns in a minischema, see Viewing Properties of Minischema Tables and Columns.