• Flashx - Saturday, November 3, 2018 3:53 PM

    Jeff Moden - Saturday, November 3, 2018 12:04 PM

    While I appreciate some of the technical aspects of the script, silently dropping existing views scares the heck out of me.  I'd recommend adding a parameter that would default to producing a list of views that were going to be dropped without dropping them so that the DBAs and Developers don't come after me with blood in their eyes.

    I added a @Execute parameter (by default to True) that will permit to chose to really drop/create views or just produce scripts.

    Excellent.  Thanks for helping folks out.  In that same vein, though, I'd default it to "False" (as in to NOT execute by default) to force people to make the choice.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)