PDA

View Full Version : SQL Script Sequence



JohnathanR
01-20-2005, 12:53 PM
How can I tinker with the execution order of my SQL Scripts?
Are they just run in the order in which they appear in the Installation Designer?

I have one script that creates a database, but my other script needs to delete that database....so I need to know how to tweak the SQL Script order.

Thanks,

John

PlzHelpThx
01-20-2005, 01:25 PM
Yes they execute in order from top to bottom.

Notice you can right click an SQL script and move it up or down.

JohnathanR
01-20-2005, 01:30 PM
I figured as much...then I noticed that move up/down thing :)

Thanks for the help