Create Database and it's tables in 1 script

Question

I'm new to SQL and have the follow problem:

I want 1 script where I create my database and its tables:

CREATE DATABASE TestDB;
USE TestDB
CREATE TABLE Customers
(
  CustomerID int NOT NULL,
  Company nvarchar(150) Not NULL,
  CONSTRAINT pk_CustomerID PRIMARY KEY (CustomerID)
);
// further tables with same scheme like 'Customers'

With this script, I always get the error: TestDB is not existing...

I use SQL Server Express 2008 and SQL Server Management Studio

Thanks for help!

also see this http://stackoverflow.com/questions/2668529/what-is-a-batch-and-why-is-go-used — 1010, Dec 22 '14 at 13:54

score 1 · Accepted Answer · answered Dec 22 '14 at 13:52

Try this:

   CREATE DATABASE TestDB;
   GO
   USE TestDB
   GO
    CREATE TABLE Customers
    (
      CustomerID int NOT NULL,
      Company nvarchar(150) Not NULL,
      CONSTRAINT pk_CustomerID PRIMARY KEY (CustomerID)
    );
    // further tables with same scheme like 'Customers'

Create Database and it's tables in 1 script

1 Answers1