Perform the following steps to display the information related to columns:
-
From the Resources window, expand a resource, right-click the desired table, and point to View.
-
Click one of the following commands on the shortcut menu:
-
SQLColumns
Displays the columns of the selected table.
-
SQLPrimaryKeys
Displays the columns that make up the primary key for the selected table.
-
SQLForeignKeys, related
Displays the list of foreign keys in the selected table and their related primary keys.
-
SQLForeignKeys, in this
Displays the list of foreign keys in the selected table and their related primary keys.
-
SQLStatistics
Displays a list of statistics about a single table and the indexes associated with the table.
A separate window appears with the results in the results pane.
-
-
To save the results as a text file, right-click the results pane and click Save Result Set As.
The Save dialog box appears.
-
Navigate to the desired folder, type a name in the File name box, and click Save.
The file is saved.
