"Quadrant" Table Viewer

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

The Table Viewer displays data in rows and columns, which allows you to compare values across records. It is useful for showing collections of records, where each row corresponds to a record. In addition, Microsoft code name “Quadrant” will automatically virtualize tables that contain a large amount data sets. This means that records not in view are not rendered.

This topic describes the UI features for the Table Viewer. You can create custom Table Viewers to filter and format the data you see.

Table Viewer Settings

You can set the following options for the Table Viewer in theworkpad or through the Data menu. After changing the viewer, you can save it by selecting Save View As on the Workpad menu. To make this custom viewer the default viewer for the Table view, select Set As Default View on the Workpad menu. By doing so, any records of the same type that are viewed subsequently in a Table Viewer will be displayed in the same settings..

In addition, you can customize a viewer by modifying its configuration template. For more information, see How to: Customize a Viewer Using a Configuration Template.

Changing Table Size

Enlarging the workpad when scrollbars are visible enables you to see more of the table’s content. To resize the workpad so that the table content is more visible, drag a corner of the workpad, and change both its height and width.

Showing and Hiding Columns

When viewing data in a Table Viewer, you can add or remove columns to be displayed in the table by selecting Column Settings on the Data menu. Alternatively, right-click the column headerclick Column Settings, and then select the columns to include in the table. By customizing the table viewing experience, you can build a representation that includes only relevant data.

Notice that a column menu remains active until deactivated. For example, if you show or hide a column, the menu stays open.

Sorting Columns

Sort data in a column by clicking the column header. By default, content is sorted in ascending order, as indicated by an upper arrow in the header. Clicking the header again will sort the data in descending order.

Resizing Columns

The default width of a column is determined by the size of the contents of that column. You can resize a column by dragging the right edge of a column header. You can also fit the column to content size by double-clicking the right edge of the column header.

Switching the Viewer for a Column

You can select a cell in the Table Viewer and choose a different viewer for the whole column from a list of associated viewers for the type. Each cell in the column will then be displayed by using the selected viewer. To change the viewer for a column, click the column header, and on the Data menu, click View Column As. Alternatively, right-click the column header, click View Column As, and select a viewer.

Adding and Deleting Rows

You can add a new record to the collection so that it shows up as a new row in the table. To add a record, on the Data menu, click Insert Item. A new workpad opens, displaying the available fields for this new record. Enter the values for each field, and on the File menu, click Save Changes to commit this new row to the database.

To delete a record from the collection, click the icon on the left of the row to highlight the whole row. On the Data menu, click Delete Item. Alternatively, right-click the icon on the far left of a row and click either Insert Item or Delete Item. On the File menu, click Save Changes to commit this change to the database.

Warning

You cannot delete a record that references data in other tables by using a foreign key. An error will occur when you try to commit the change. View the error details by double-clicking Errors (n) at the lower-right corner of the screen.

Examining a Row in Detail

To examine a row in detail, drag the icon to the left of the row to an empty place in the workspace. A new workpad opens that displays the record in a Properties Viewer.