Creating a database through an sql script and then using that database

Question

I have a script which uses an existing database to create tables and enter values. Now I wish to create the database through this same script and then create the tables and values which are just a copy of another database.

I have:

CREATE DATABASE MyDatabase

USE [MyDatabase]
....Code that creates the tables and values from another database.

The USE [MyDatabase] command is not recognized since MyDatabase does not exist anywhere yet. Is there a way around this?

Kyle Hale · Accepted Answer · 2013-03-08 19:38:08Z

2

Yes, insert the GO command in between your scripts.

CREATE DATABASE MyDatabase
GO
USE [MyDatabase]

answered Mar 8, 2013 at 19:38

Kyle Hale

8,1301 gold badge40 silver badges59 bronze badges

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

6 Comments

Joel Coehoorn Over a year ago

Be careful with this. GO is not part of the SQL language. It works with some tools, because those tools are configured specially to look for it... but they can be set not to look for it, or to look for something else instead.

zms6445 Over a year ago

How do you set the directory in which the database is created in?

Kyle Hale Over a year ago

CREATE DATABASE has syntax for that. msdn.microsoft.com/en-us/library/ms176061.aspx

Aaron Bertrand Over a year ago

@JoelCoehoorn for fun set your batch separator to SELECT or FROM :-)

Joel Coehoorn Over a year ago

@AaronBertrand or even better, a co-worker's separator when you catch him away from his desk

|

Collectives™ on Stack Overflow

Creating a database through an sql script and then using that database

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related