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!

just type "Go" before "Use TestDB"

Muhammad Gouda
– Muhammad Gouda

2014-12-22 13:51:55 +00:00
Commented Dec 22, 2014 at 13:51 — Muhammad Gouda
– Muhammad Gouda, Commented Dec 22, 2014 at 13:51
Try add the GO keyword between commands.

Sparky
– Sparky

2014-12-22 13:52:02 +00:00
Commented Dec 22, 2014 at 13:52 — Sparky
– Sparky, Commented Dec 22, 2014 at 13:52
also see this stackoverflow.com/questions/2668529/…

1010
– 1010

2014-12-22 13:54:12 +00:00
Commented Dec 22, 2014 at 13:54 — 1010
– 1010, Commented Dec 22, 2014 at 13:54

Sparky · Accepted Answer · 2014-12-22 13:52:51Z

1

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'

answered Dec 22, 2014 at 13:52

Sparky

15.1k2 gold badges34 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

Create Database and it's tables in 1 script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related