Creating Models › Creating a Physical Model › Stored Procedures › Change the Order in Which Stored Procedures Generate

Change the Order in Which Stored Procedures Generate

The order in which you add stored procedures to your model is important. The stored procedure code is generated according to the order the stored procedures display in the Stored Procedure Editor. You can change this order at any time by using the up and down arrow buttons on the Object Creation Order tab in the Stored Procedure Editor.

To change the order in which stored procedures generate

1. Click Stored Procedures on the Model menu in a physical model.

   The Stored Procedure Editor opens.

2. Click the Object Creation Order tab.
3. Use the buttons on the toolbar change the generation order of a selected stored procedure. Move the stored procedure up in the list if you want it to generate before the others below it, or move the stored procedure down in the list if you want the selected stored procedure to generate after the others above it.
4. Click Close.

   Your changes are saved and the Stored Procedure Editor closes.

More information:

Define a Stored Procedure