View columns
A column in a view is not stored in the database—it is derived from the SELECT query that defines the view.
In Database Explorer, you can perform operations on columns by using the shortcut menu. Right-click a column to access options such as viewing column properties.
View the column properties
View the column properties in one of these ways:
- Double-click the required column.
- In Database Explorer, right-click the column and select Show Details.
Object Viewer opens, displaying detailed information about the column.
Refresh the column
To update the column to reflect the latest changes, in Database Explorer, right-click the column or Columns node and select Refresh, or press F5.
Open the Properties window
To open the Properties window, in Database Explorer, right-click the column and select Properties, or press F4.
Filter columns
1. In Database Explorer, right-click the Columns node and select Filter.
2. In the Filter Settings dialog, configure the filter parameters.
3. Click OK to apply the filter.
Note
When you open the Columns node, the number of objects it contains appears in parentheses next to the node name. This number changes based on your filter settings.
Shortcut menu options for a column
The following table describes the shortcut menu options available for a column in Database Explorer.
| Name | Description |
|---|---|
| Show Details | Opens Object Viewer that displays object details. |
| Source Control > Source Control Manager | Opens Source Control Manager, where you can track and manage changes to database schema and static data. When Source Control Manager is already open, this option refreshes it. |
| Source Control > Commit | Opens Source Control Manager with all local changes (if any) selected and ready to commit. When Source Control Manager is already open, this option refreshes it and selects all local database changes. |
| Source Control > Get Latest | Opens Source Control Manager with all remote changes (if any) selected, ready to retrieve using Get Latest. When Source Control Manager is already open, this option refreshes it and selects all remote database changes. |
| Refresh | Updates the object to reflect the latest changes. Shortcut: F5 |
| Properties | Opens the Properties pane that displays object details. Shortcut: F4 |
Shortcut menu options for the Columns node
The following table describes the shortcut menu options available for the Columns node in Database Explorer.
| Name | Description |
|---|---|
| Source Control > Source Control Manager | Opens Source Control Manager, where you can track and manage changes to database schema and static data. When Source Control Manager is already open, this option refreshes it. |
| Source Control > Commit | Opens Source Control Manager with all local changes (if any) selected and ready to commit. When Source Control Manager is already open, this option refreshes it and selects all local database changes. |
| Source Control > Get Latest | Opens Source Control Manager with all remote changes (if any) selected, ready to retrieve using Get Latest. When Source Control Manager is already open, this option refreshes it and selects all remote database changes. |
| Filter | Opens the Filter Settings dialog to control which columns should appear in the view in Database Explorer. |
| Show Details | Opens Object Viewer that displays object details. |
| Refresh | Updates the object to reflect the latest changes. Shortcut: F5 |
Bulk operations
In Database Explorer, hold down Ctrl and select multiple columns. Then right-click the selection and select the required option.
The following table describes the shortcut menu options available for multiple columns.
| Name | Description |
|---|---|
| Source Control > Source Control Manager | Opens Source Control Manager, where you can track and manage changes to database schema and static data. When Source Control Manager is already open, this option refreshes it. |
| Source Control > Commit | Opens Source Control Manager with all local changes (if any) selected and ready to commit. When Source Control Manager is already open, this option refreshes it and selects all local database changes. |
| Source Control > Get Latest | Opens Source Control Manager with all remote changes (if any) selected and ready to retrieve using Get Latest. When Source Control Manager is already open, this option refreshes it and selects all remote database changes. |
| Source Control > Link/Unlink Static Data | Opens the Source Control Link Static Data dialog that displays the tables whose data you want to link. |
