Viewing the Fields in a Table

Overview

You can review information about the fields contained in the selected table by using the Fields tab to display metadata for the fields in a table. You can display this tab in any context in which a table can be selected.

To view the fields, right-click a table, select Open, and click the Fields tab. Alternatively, from the desktop, click the Data Connections riser bar. Then, open a connection and select a table. Finally, click the Fields tab on the right.

The following information is displayed for each field in the selected table:

• Name
• Role
• Type
• Length
• Decimal
• Is Nullable
• Description