Physical Modeling › Stored Procedures › Add a Stored Procedure for a Table or View › Define the Stored Procedures SQL Code

Define the Stored Procedures SQL Code

You can use the Code tab in the Stored Procedures Scripts dialog to review or assign code (including macros) to a stored procedure

To define the stored procedure SQL code

1. Click Stored Procedures, Model-Level or Table-Level on the Database menu.

   The Stored Procedures dialog opens.

2. Click the Code tab.

   The code for the selected script is displayed.

3. Click Macro Toolbox.

   The Macro Toolbox opens. You can select a macro to add to the script.

4. You can complete the fields on the General and Expanded tabs and then optionally select the Comment or UDP tab to add a comment or user defined property. Click OK.

   Your changes are saved and the Stored Procedures dialog closes.

   Note: Click Cancel to close the dialog without saving your changes.