Physical Modeling › Stored Procedures › Stored Procedure Browser

Stored Procedure Browser

Use the Stored Procedure Browser to see the tables and views that are attached to a table-level stored procedure, view the code that is used by a table-level stored procedure, and attach tables and views in a model to a stored procedure. The following list describes the fields used by the Stored Procedure Browser:

SP Template Name

Displays the names of all the available table-level stored procedure templates.

SP Template Code

Displays the template code for each of the available table-level stored procedure templates.

Unattached Table

Displays the available tables and views to which you can attach a table-level stored procedure. Select one of the available table-level stored procedure templates from the SP Template Name list that you want to attach.

Attached Table

Displays the list of tables and views that are currently attached to the selected table-level stored procedure template.

SP Template [Read Only]

Displays the code for the selected table-level stored procedure.

SP Expansion [Read Only]

Displays the code of the table-level stored procedure as it will appear in the physical schema.

Attach to New Table

Attaches the stored procedure to each new table or view that you create when you select this check box.

More information:

View the Tables and Views Attached to a Stored Procedure Template

Attach a Table or View to a Stored Procedure Template

Detach a Table or View from a Stored Procedure Template

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

Teradata Browser Editor for Functions, Script Templates, and Stored Procedures

Attach or Detach a Teradata Table or View to a Macro

Attach or Detach a Teradata Table or View to a Stored Procedure