How to create and use database directly after creation in SQL Server?

Question

I created a sql script to check if a database already exist, if it already exists it deletes and re-creates.
After I would like to connect it directly after its creation for creating tables ..

Here is my code but it does not work, it produces the following error:

Msg 911, Level 16, State 1, Line 10
Database 'Arms2' does not exist. Make sure that the name is entered correctly.

My script

IF EXISTS (select * from sys.databases where name = 'Arms2')
BEGIN 
    DROP DATABASE Arms2
    PRINT 'DROP DATABASE Arms2'
END
    CREATE DATABASE Arms2;
    PRINT 'CREATE DATABASE Arms2'

USE Arms2

CREATE TABLE .....

AdaTheDev · Accepted Answer · 2013-01-24 10:46:29Z

12

Put a GO statement after the CREATE...

...
CREATE DATABASE Arms2;
PRINT 'CREATE DATABASE Arms2'
GO
USE Arms2

answered Jan 24, 2013 at 10:46

AdaTheDev

148k28 gold badges215 silver badges204 bronze badges

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

4 Comments

Mehdi Bugnard Over a year ago

Thank you very much! Everything works perfectly. Can explain why it was necessary to add "GO"?

Bridge Over a year ago

@MehdiBugnard It's a "splitter" for certain Microsoft products (SSMS/OSQL) that tells the system to split the script into two batches. It's not a real keyword, in fact you can change it to something else from the options menu in SSMS.

AdaTheDev Over a year ago

Also, just to provide the MSDN reference - msdn.microsoft.com/en-gb/library/ms188037.aspx

Simon Morgan Over a year ago

GO is specific to SQL Server Management Studio and so isn't recognised by SQL Server.

Collectives™ on Stack Overflow

How to create and use database directly after creation in SQL Server?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related