Columns Branch
This branch of the tables list shows all the columns of the table. If your table contains binary or overlap type columns, they will be shown. To indicate that you cannot use these columns for the data view, the picture is changed.
If you expand the Columns Branch, you can select from the list of available columns, then right-click and select Rebuild DataView from the context menu to only see the selected columns.
Context Menu
The floating menu on Columns contains the following choices:
| Option | Action |
|---|---|
| Rebuild DataView | Use the selected columns and rebuild the dataview based on this information |
| Select all columns | Select all the columns of the current table |
| Deselect all columns | Deselect all the selected columns |
| Show column attributes | Switch to the columns tab page in the dataview so that you can view the column attributes |
| Sort columns by Name | Sort the names of the columns by name (alphabetically) |
| Sort columns by Number | Sort the names of the columns by number |
| Find Column by Name | Find a column by its name |
| Find Next Column | Find the next occurrence of the column name |
| Add Column Numbers | Add the number of each column to the label |
| Select columns from data display | Select all the columns that are currently used in the data display (grid or single record view mode) |
| Expand Columns Branch | Expand the treeview node |
| Collapse Columns Branch | Collapse the treeview node |
The context menu for each individual column contains the following choices:
| Option | Action |
|---|---|
| Jump to this Column | Jump to this column in the datagrid |
| Rebuild DataView | Use the selected columns and rebuild the dataview based on this information |
| Show Column Attributes | Switch to the columns tab page in the dataview so that you can view the column attributes |
| Find Column by Name | Find a column by its name |
| Find Next Column | Find the next occurrence of the column name |