Generate Drop / Create Script for views, stored Procedures

Question

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

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

Wyatt Winghead Old Hand Points: 316 More actions · Answer 1

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

Lata Patel SSC Enthusiast Points: 159 More actions · Answer 2

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

tskelley SSCommitted Points: 1870 More actions · Answer 3

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.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 4

SSC Guru

Points: 76202

May 2, 2016 at 4:13 pm

Thanks for the script.