Viewing Properties of Minischema Columns, Relational Source Columns, and User-Defined Table Columns

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

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

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

  3. Right-click the table and select Properties, and then select the Columns tab.

    These column properties are displayed:

    • Column name

    • Physical source table name

    • Column type

    • Whether nulls are allowed

    Note:

    If you are viewing the column properties from the Column tab of the Table Properties dialog box, a key symbol is displayed next to the key column, if any, for the table.