How to add/edit a table valued function call

Adding a table valued function call

To add a table valued function call, in Catalog Explorer right-click the catalog, schema or Table Valued Functions node and choose Create Call Definitions to Table Valued Functions. This will bring up the Reverse Engineering Element Editor with the Table Valued Functions to which you can specify a call definition and as well select the return type, which will be mapped onto the resultset.

You can also select one or more individual table valued functions, right-click and select Create Table Valued Function Call Definitions which will bring up the Reverse Engineering Element Editor.

Alternatively you can right-click the 'Table Values Function Calls' node in a group in the Project Explorer and select 'Reverse engineer table-valued functions to table-valued function calls' from the context menu.

Editing a table valued function call

To edit a table valued function call, right-click it in the Project Explorer and choose Edit... from the context menu. This will bring up the Table Valued Function Call Editor.

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.