Database doesn't exist

Question

I use sql server 2014 and with following piece of code:

if db_id('handel') is not null
    drop database handel;

create database handel;
use handel;

I get the error: Database 'handel' does not exist. Make sure that the name is entered correctly. on line use handel, which blows my mind a bit, as just a line before I create said database. Could anyone please help?

knkarthick24 · Accepted Answer · 2014-12-18 12:04:17Z

6

You missed GO Keyword:

if db_id('handel') is not null
    drop database handel;

create database handel;
GO
use handel;

answered Dec 18, 2014 at 12:04

knkarthick24

3,24619 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Database doesn't exist

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