Creating Models › Target Servers for Physical Models › Database Property Editors › Common Property Pages › Change the Object Creation Order for Tables or Views

Change the Object Creation Order for Tables or Views

The Object Creation Order tab that appears in the Table Editor and the View Editor lets you manage the creation order of functions, script templates, and stored procedures for the selected table or view. The default order is the order in which each object was created.

Note: You cannot add, modify, or delete any objects using this tab.

To change the object creation order

1. Open either the Table Editor or the View Editor, depending on the physical object for which you want to change the object creation order, and click the Object Creation Order tab.

   The Object Creation Order tab opens.

2. Work with the following options from the Display drop-down:

   Functions

   Specifies to display the available functions for which you can change the creation order. Click the Function Browser button to open the Functions Browser to see the tables and views that are attached to a function and to view the template code. Click the Function Editor button to open the Function Editor to manage function properties.

   Script Templates

   Specifies to display the available script templates for which you can change the creation order. Click the Script Template Browser button to open the Script Template Browser Editor to see the tables and views that are attached to a script template and to view the template code. Click the Script Template Editor button to open the Script Template Editor to manage script template properties.

   Stored Procedures

   Specifies to display the available stored procedures for which you can change the creation order. Click the Stored Procedure Browser button to open the Stored Procedures Browser Editor to see the tables and views that are attached to a stored procedure and to view the template code. Click the Stored Procedure Editor button to open the Stored Procedure Editor to manage stored procedure properties.

3. Click the Sort Items button, select Creation Order, and then verify and change the creation order of the objects using the up and down arrow buttons, then click Close.

   The object creation order is changed and the property editor closes.