Show TOC

Rebuilding Procedures Attached to TablesLocate this document in the navigation structure

You can rebuild procedures attached to tables at any time.

Procedure

  1. Select Start of the navigation path Tools Next navigation step Rebuild Objects Next navigation step Rebuild Table Stored Procedures End of the navigation path to open the Rebuild Table Stored Procedures window.


  2. Specify a rebuild mode. You can choose between the following options:

    • Delete and Rebuild – all procedures attached to tables are deleted and rebuilt

    • Add missing table stored procedures – adds procedures to any selected tables that do not presently have them.

  3. [optional] Click the Selection tab to specify for which tables you want to rebuild stored procedures.
  4. Click OK to begin the rebuild process.