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