T-SQL Tutorial

Msg 2714 Level 16 - There is already an object named in the database


Transact sql error message Msg 2714 Level 16 - There is already an object named in the database - means that the table is already created in the database.





Msg 2714 Level 16 Example:

USE model;
GO
CREATE TABLE students(
id INT NOT NULL PRIMARY KEY,
first_name CHAR(50),
last_name CHAR(50),
gender CHAR(1),
city CHAR(100),
country CHAR(50),
dep_id INT);
GO

Message
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'students' in the database.

Other error messages: