Previous Topic: Define SQL Azure Stored ProceduresNext Topic: Synonym Properties

Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in CA ERwin Data Modeler › Stored Procedure Properties › SQL Azure Browser for Functions, Script Templates, and Stored Procedures

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

When you are in either the SQL Azure Function Editor, SQL Azure Script Template Editor, or the SQL Azure Stored Procedure Editor, you can click the Browser button Macro/Stored Procedure Browser Icon to open either the SQL Azure Function Browser, SQL Azure Script Template Browser, or the SQL Azure 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 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, 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.