Drop all nettiers procedures

Reply

smallinov Posted: Wed, Apr 18 2007 10:48 AM

rated by 0 users

Someone may have aleady posted something like this but I couldn't find it.

Bascially I wanted to drop all of my nettiers procedures and regenerate as sort of a house cleaning. I had some tables that I am no longer generating for and the procedures stayed out there. This only works if you are using a prefix or suffix as you will notice. The other time this comes in handy is during the intial stages of db development / generation where you may chang your mind often about how you want things set up.

Enjoy.

-Ryan

USE YourDBName
GO

DECLARE @procedureName SYSNAME
DECLARE c CURSOR FOR

SELECT name FROM sysobjects WHERE type = 'P' AND objectproperty(id, 'IsMSShipped') = 0 AND name LIKE 'yourProcedurePrefixHere%'

OPEN c

FETCH NEXT FROM c INTO @procedureName

WHILE @@FETCH_STATUS = 0

EXEC('DROP PROC ' + @procedureName)

FETCH NEXT FROM c INTO @procedureName

CLOSE c

DEALLOCATE c

Reply

swin replied on Sun, Apr 22 2007 4:08 PM

rated by 0 users

Nice! So nice I wrapped it up as a patch to the templates ... http://community.codesmithtools.com/forums/23942/ShowThread.aspx#23942

Thanks

swin

Reply

smallinov replied on Mon, Apr 23 2007 12:27 PM

rated by 0 users

Awesome! Glad to see it is now a feature :-)

 -Ryan