Rebuilding Procedures Attached to Tables

You can rebuild procedures attached to tables at any time.

1. Select Tools > Rebuild Objects > Rebuild Table Stored Procedures 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.