To view the properties of a relational source table or user-defined table:
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.
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.
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.