how to check database already exists in sql server? and how stop the query if database already exists?

Question

I have a query like this:

IF EXISTS(select name from sys.databases where name = 'AdventureWorks')
   use AdventureWorks

I want to use AdventureWorks if it already exists, but if it doesn't exists, I want to create the AdventureWorks database.

Help me please.

Not sure: CREATE DATABASE AdventureWorks WHERE NOT EXISTS(select name from sys.databases where name = 'AdventureWorks') — Mihai
– Mihai, Commented Aug 9, 2014 at 14:27

Roger Wolf · Accepted Answer · 2014-08-09 14:31:22Z

1

if db_id('Test1') is not null
    set noexec on;

create database Test1;

set noexec off;

It seems, though, that you cannot switch the database context with USE in the same batch that creates it - MSSQL fires an error. So split it into 2 queries.

answered Aug 9, 2014 at 14:31

Roger Wolf

7,7872 gold badges29 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to check database already exists in sql server? and how stop the query if database already exists?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related