Physical Modeling › Stored Procedures › Procedure Browser

Procedure Browser

Use the 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 Procedure Browser contains the following fields:

Template Name/Template Code

Displays the names of all the available table-level stored procedure templates and their template code.

Unattached Object

Displays the available tables and views to which you can attach a table-level stored procedure.

Attached Object

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

Template (Read Only)

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

Template Expansion (Read Only)

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

More information:

View the Tables and Views Attached to a Stored Procedure

Attach a Table or View to a Stored Procedure

Detach a Table or View from a Stored Procedure

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