Creating Models › Creating a Physical Model › 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 Procedure Editor to review or assign code (including macros) to a stored procedure.

To define the stored procedure SQL code

1. Click Stored Procedures on the Model menu.

   The Stored Procedure Editor opens.

2. Click the Code tab to review the SQL code and make any necessary changes.
3. (Optional) Click the Macro Toolbox button to work with macros.
4. Click Close.

   Your changes are saved and the Stored Procedure Editor closes.