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.
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.