How do I exit from a SQL Server batch script?

Question

I'm creating views and stored procedures in my database via a script. If a certain table does not exist, I don't want to create some of the objects, so I want to exit the script at that point, or put a condition if/then loop around that part of the script.

Quit doesn't work, and I've tried EXIT, but get an error.

I did the if exists thing, but there are many objects I want to create if a certain table exists. I tried a begin end loop, but got an error with that, too. if exist (anntab)
begin create view1 go create view2 go create storedproc1 go end
gives me errors.

Answer 1

The command is EXIT or QUIT

Answer 2

it truly is not any longer genuine clean. There are different styles of scripts which will be utilized in a sq. Server surroundings. i'd imagine sq. scripting may be what they are which ability although.

Answer 3

if exists (select * from sysobjects where name = 'MyObject')
--add your create script here

GO

so long as the conditions are met in the if statement, the next statement will execute.