Chapter 6 Building Triggers and Procedures

Rebuilding procedures attached to tables

You can rebuild procedures attached to tables at any time.

To rebuild procedures attached to tables manually:

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.

Copyright (C) 2007. Sybase Inc. All rights reserved.