Typed View Editor, Fields Tab

The Fields tab contains the information and editors for working with the fields of the typed view. In general, a typed view is created through reverse engineering a table, view or table-valued function resultset / stored procedure resultset. It is possible to add new fields to a typed view, or edit the field aspects like type, length, precision and scale. Adding fields to a typedview while the target is a view or stored procedure resultset is only useful if the target has unmapped fields as the view or stored procedure resultset isn't changeable.

Typed View Fields Tab

The Fields tab

The fields are shown in a grid, and directly editable. To add a new field, click in the top-row of the grid or (when the grid already has focus) press Ctrl-Shift-F to add a new field to the typed view. You don't have to specify all the columns, only the first two, Name and Type are mandatory.

When you've specified enough information for the field, press Ctrl-Enter to add the field. A new field will automatically get a target field mapped, if the designer can find an unmapped field in the mapped target element (if the typed view is mapped to a target (table/view/stored procedure resultset) already) matching the newly added field.

Editing fields uses type shortcuts for specifying types easily. You can type the first characters of the type shortcut to make the grid automatically pre-select the type(s) matching the characters typed, like intellisense. Pressing TAB will move the focus to the next column. To edit the Description, move to that column using TAB or cursor keys and press Ctrl-DownArrow to open the small text editor to specify a description for a field. Descriptions are generated as XML DOC comments into the output.

To remove one or more fields, you have to select the fields using the row headers in the grid and click the Remove Selected button at the bottom of the subtab.

To set the field order for the fields, click the Set Field Ordering button, which will bring up the Field Order Selector to specify the field ordering for the typed vieww.