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?

score 2 · Accepted Answer · answered Mar 08 '13 at 19:38

2

Yes, insert the GO command in between your scripts.

CREATE DATABASE MyDatabase
GO
USE [MyDatabase]

answered Mar 08 '13 at 19:38

Kyle Hale

7,912
1
37
58

1

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. – Joel Coehoorn Mar 08 '13 at 19:40
How do you set the directory in which the database is created in? – zms6445 Mar 08 '13 at 19:42
1

CREATE DATABASE has syntax for that. http://msdn.microsoft.com/en-us/library/ms176061.aspx – Kyle Hale Mar 08 '13 at 19:44
1

@JoelCoehoorn for fun set your batch separator to `SELECT` or `FROM` :-) – Aaron Bertrand Mar 08 '13 at 19:56
@AaronBertrand or even better, a co-worker's separator when you catch him away from his desk – Joel Coehoorn Mar 08 '13 at 20:37
@Joel well, yes, that's what I meant, but didn't want to catch flack if someone got caught doing that. :-) – Aaron Bertrand Mar 08 '13 at 20:44

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

1 Answers1