Table Valued Function Call Editor

The Table Valued Function Editor is the editor which allows you to alter any aspect of a table valued call definition: its parameters, the parameter mappings, the resultset mappings and its code generation information. You open a table valued function call definition in its Table Valued Function Call Editor by selecting it in the Project Explorer and then right-clicking it and selecting Edit..., or by pressing Ctrl-Shift-O.

The Table Valued Function Call editor consists of the following main parts:

Parameters tab

This tab contains the information and editors for working with the parameters of the table valued function call definition

Mappings tab

This tab contains the information and editors for working with the mappings of the parameters of the table valued function call definition on the parameters of the target table valued function in the Relational Model Data

Code generation info tab

This tab contains the information and editors for the code generation related data of the table valued function call.

At the top of the Table Valued Function Call Editor you'll find the following editor elements:

Table Valued Function Call name

This is the name of the table valued function call definition

Group name

This is the name of the group the table valued function call definition is in. You can select an existing one or specify a new one. If left empty, the table valued function call definition is in the unnamed group

Return element

The element to return by the table valued function call, which is the element mapped onto the resultset. Altering this will alter the mappings of the resultset of the table valued function call.

For return types you can choose from the available entities or typed views. Entities in an inheritance hierarchy aren't supported as return type.

The General Table Valued Function Call Editor

The designer also offers a General Table Valued Function Call Editor. This is a special kind of Table Valued Function Call editor which allows you to edit the table valued function call which is currently selected in the project explorer. This editor is opened by selecting Project -> General Table Valued Function Call Editor in the menu, or by clicking the button in the toolbar.

The advantage of the General Table Valued Function Call Editor is that it keeps the current sub tab selected when you select another table values function call in the project explorer, which allows you to e.g. edit the mappings of several table values function calls without a lot of clicking through tabs.