Generate Drop / Create Script for views, stored Procedures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by doktor-kermit » Generate Drop / Create Script for views,...

Generate Drop / Create Script for views, stored Procedures

Rate Topic

Display Mode

Topic Options

Author

Message

doktor-kermit

Posted Saturday, October 20, 2007 10:14 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:10 AM
Points: 99, Visits: 85

Comments posted to this topic are about the item Generate Drop / Create Script for views, stored Procedures

Post #413155

Wyatt Winghead

Posted Monday, January 14, 2008 5:31 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 11:39 PM
Points: 61, Visits: 54

One can also use this for functions, defaults, rules, and triggers

Post #442778

Lata Patel

Posted Thursday, September 23, 2010 1:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, August 10, 2011 8:48 AM
Points: 7, Visits: 31

The script giving syntax error..please upload again...Thanks..

Post #991777

tskelley

Posted Tuesday, January 01, 2013 5:18 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, June 14, 2013 2:51 PM
Points: 33, Visits: 773

Lata Patel (9/23/2010)

The script giving syntax error..please upload again...Thanks..

Just do a find/replace with the characters holding the indentation formatting. I replaced w/ a space and worked fine.

Thanks for a cool use of the system tables.

Post #1401580

« Prev Topic | Next Topic »

Permissions