Explore our sites

Stack Exchange
tour help careers 2.0
Take the tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

This question may related to Checking if database exists or not in SQL Azure.

In SQL Azure, I tried to use a script like this to check the existence of a database, and create the database if it doesn't exist yet (in both SQLCmd and SSMS): 

IF db_id('databasename') IS NULL CREATE DATABASE databasename
GO

However, SQL Azure keeps telling me 

Msg 40530, Level 16, State 1, Line 2
The CREATE DATABASE statement must be the only statement in the batch.

While the same script did work on a local SQL express instance.

Does this mean it is not supported on SQL Azure? Or is there any work around?

Thanks in advance.

Eidt: Let me clarify what I want to achieve: I want a script which will create a certain database only if it doesn't exist before. Is it possible to have such kind of script for SQL Azure?

share|improve this question
add comment

1 Answer

up vote 0 down vote

It's saying you can't do theck and create in the same piece of sql.

i.e you need to do Select IF db_id('databasename') test the whether it returns null, and if so then execute the create database.

share|improve this answer
 
Thank you for the answer. But what I want to achieve is to have a script to create a certain database only if it doesn't exist. Is it possible to have such a script for SQL Azure? –  Shane Lu Jun 2 at 12:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.