Creating Models › Creating a Physical Model › Stored Procedures › Add a Stored Procedure for a Table or View › Review the Expanded SQL Code for a Stored Procedure

Review the Expanded SQL Code for a Stored Procedure

You can use the Expanded tab in the Stored Procedure Editor to review the code assigned to a stored procedure as it will appear in the physical schema. This tab enables you to view the code in an enlarged window.

Note: You cannot edit the code in this tab. Use the Code tab to make any changes to the SQL code or assign macros.

To review the expanded stored procedure SQL code

1. Click Stored Procedures on the Model menu.

   The Stored Procedure Editor opens.

2. Click the Expanded tab and review the SQL code.
3. Click Close.

   The Stored Procedure Editor closes.