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

Define the Stored Procedures Expanded SQL Code

You can use the Expanded tab in the Stored Procedures Scripts dialog 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. However, you cannot edit the code in this tab.

To define the stored procedure Expanded SQL code

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

   The Stored Procedures dialog opens.

2. Click the Expanded tab.

   The stored procedure code as it will appear in the physical schema is displayed for the selected stored procedure.

3. Click the Text Editor icon.

   A new dialog where you can edit the code and review the expanded code opens. You can also access the Macro Toolbox and text editing tools in this dialog.

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.