"There is already an object named XXXX in the database" after creating New database

Question

I have an SQL file which I am executing on an SQL Server instance which contains the schema for a database. The file creates a brand new database (as in, a database with this name does not exist on this server):

CREATE DATABASE PROJECT;

and begins to create a relation:

CREATE TABLE Courses (
  CourseID INT NOT NULL PRIMARY KEY,
  Name VARCHAR(64) NOT NULL UNIQUE,
  Code CHAR(4) NOT NULL UNIQUE
);

...

and here is what SQL Server tells me right off the bat:

Msg 2714, Level 16, State 6, Line 3
There is already an object named 'Courses' in the database.

Any idea why SQL Server tells me that there already exists a relation by the name of Courses when clearly there isn't?

Thank you for your time.

after creating the database, try executing this query USE PROJECT;, and run the DDL again. — John Woo
– John Woo, Commented Nov 19, 2012 at 1:44
One drawback... After creating the PROJECT database and executing USE PROJECT; I get: Msg 911, Level 16, State 1, Line 3 Database 'PROJECT' does not exist. Make sure that the name is entered correctly. — Oliver Spryn
– Oliver Spryn, Commented Nov 19, 2012 at 1:46
In SSMS, you'll need a GO between the Create database, and the USE statement — Adam Wenger
– Adam Wenger, Commented Nov 19, 2012 at 1:46

John Woo · Accepted Answer · 2012-11-19 01:47:19Z

5

Check the database if you are using PROJECT

CREATE DATABASE PROJECT
GO

USE PROJECT
GO

CREATE TABLE Courses 
(
  CourseID INT NOT NULL PRIMARY KEY,
  Name VARCHAR(64) NOT NULL UNIQUE,
  Code CHAR(4) NOT NULL UNIQUE
)
GO

answered Nov 19, 2012 at 1:47

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

4 Comments

Oliver Spryn Over a year ago

I'm not real knowledgeable about the vendor specific T-SQL. Could you explain what GO does, in this case?

Code Magician Over a year ago

GO is not the same thing as ; in mysql. Go separates batches of commands. ; ends a statement (in both mysql and T-SQL) and many statements can be part of a batch. msdn.microsoft.com/en-us/library/ms188037.aspx

Oliver Spryn Over a year ago

@M_M Hmm... I didn't know ; wasn't required in TSQL! Thanks!

Code Magician Over a year ago

Generally not required except using Common table expressions. The WITH must either be the first stament in a batch, or be preceded with a ;

Dmitry Frenkel · Accepted Answer · 2012-11-19 01:46:26Z

3

You are likely missing USE PROJECT statement and therefore trying to create Courses table in the master database, not in the PROJECT database.

answered Nov 19, 2012 at 1:46

Dmitry Frenkel

1,79612 silver badges17 bronze badges

Comments

David Lloyd Brookes · Accepted Answer · 2012-11-19 01:49:31Z

0

Long shot but try using:

Use project;
CREATE TABLE Courses....

answered Nov 19, 2012 at 1:49

David Lloyd Brookes

1601 silver badge10 bronze badges

Collectives™ on Stack Overflow

"There is already an object named XXXX in the database" after creating New database

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related