How can we help you today? How can we help you today?

Option to Drop/Create Procedures instead of Alter

I've looked around and I can't find this, so I'm assuming it's not there. Please correct me if it is. Is there a mechanism to force the scripts to drop procedures and recreate them rather than running ALTER statements?

The reason for this is because we have a large number of databases running in Express. We have a master database that they are all supposed to have an exact copy of, but sometimes, well, the copy isn't exact. If they have an exact copy, ALTER will work great. But if the copy is off, DROP & CREATE will work better.
Grant Fritchey
0

Comments

2 comments

Sort by
  • David Atkinson
    I'm not sure I understand. Is this because ALTER assumes the object exists, whereas DROP/CREATE will work regardless?

    David Atkinson
    Red Gate Software
    David Atkinson
    0
  • Grant Fritchey
    I must have explained that poorly, but yes, you're stating the problem exactly.
    Grant Fritchey
    0

Add comment

Please sign in to leave a comment.