Post reply

Easily delete database objects

  • April 24, 2009 at 9:33 pm

    #384444

    Comments posted to this topic are about the item Easily delete database objects

  • May 26, 2010 at 3:35 am

    #1172556

    That's a useful SP!

    To give it extra benefit you could add some checking for constraints on the object (e.g. FK on the table to be dropped) and add an option to remove the constraint(s) before dropping the object.

    Cheers,

    Rob.

  • May 26, 2010 at 9:58 am

    #1172852

    How about being able to wildcard the object name? If not, can anyone tell me how to add that to the SP?

    Before everyone jumps on me let me explain... We had someone in our organization create a process that creates "temp" tables. I put "temp" in quotes because what his procs actually do is create tables. If they user doesn't check a certain option in the application, these tables don't get dropped. We often find ourselves having to go through the DB and delete many of these. I had a script for this but I found it kind of kludgey. I really like this SP and would like to modify for this purpose.

  • May 19, 2016 at 7:03 am

    #1880211

    Thanks for the script.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply