Subject | Re: How to rebuild all stored procedures / triggers |
---|---|
Author | |
Post date | 2014-11-05T16:10:57Z |
I use IB Expert. It will build a script that alters all your stored procedures to empty. Just the input and output parameters are in place. Then it alters them again populated. This means you don't need to be concerned in what order you create them. It also will build a script that will alter all your triggers.
We do this periodically in our clients installations because we want all of them to have the exact same metadata.
We do this periodically in our clients installations because we want all of them to have the exact same metadata.