When you forward engineer a model that contains stored procedures, any stored procedures for which you have selected the Generate check box in the Stored Procedure Editor will generate in the database schema. The type of stored procedure that you specify is maintained. For example, a table-level stored procedure remains a table-level stored procedure.
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. Make sure that any table-level stored procedures that have dependencies generate in the proper sequence.
Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |