Physical Modeling › SQL Server Common Functionality › SQL Server Browser for Functions, Script Templates, and Stored Procedures

Previous Topic: Define SQL Server Assemblies

Next Topic: Define SQL Server Certificates

SQL Server Browser for Functions, Script Templates, and Stored Procedures

When you are in either the SQL Server Function Editor, SQL Server Script Template Editor, or the SQL Server Stored Procedure Editor, you can click the Browser button Macro/Stored Procedure Browser Icon to open either the SQL Server Function Browser, SQL Server Script Template Browser, or the SQL Server Procedure Browser.

Note: The Browser button is only enabled for table-level functions, script templates, or stored procedures and is not available for any of these items at the model level.

Use the browser to see the tables and views that are attached to a function, script template, or stored procedure and to view the code that is used by a particular template for a function, script template, or stored procedure. You can also attach tables and views in your model to existing functions, script templates, or stored procedures.

The following describes the options available for this browser:

Template Name/Template Code

Displays the name of each function template, script template, or stored procedure template in the model, along with the first line of code from either the function template, script template, or stored procedure template. This can include SQL statements and macros.

Unattached Object

Lists all of the tables and views in the model that are not attached to the selected function template, script template, or stored procedure template. Select an object and click the erw_hlp--function_script_st_proc_browser--single right arrow button--SCR button to attach that item to the selected function template, script template, or stored procedure template. Click the erw_hlp--function_script_st_proc_browser--double right arrow button--SCR button to attach all items in the Unattached Object list. Any item you attach is moved out of the Unattached Object list and placed into the Attached Object list.

Attached Object

Lists all of the tables and views that are attached to the selected function template, script template, or stored procedure template. Select an object and click the erw_hlp--function_script_st_proc_browser--single left arrow button--SCR button to unattach that item from the selected function template, script template, or stored procedure template. Click the erw_hlp--function_script_st_proc_browser--double left arrow button--SCR button to unattach all items in the Attached Object list. Any item you unattach is moved out of the Attached Object list and placed into the Unattached Object list.

Template (Read Only)

Displays the template code for the selected function template, script template, or stored procedure template.

Template Expansion (Read Only)

Displays the expanded template code for the selected function template, script template, or stored procedure template.