Table already Exists??

• t.e.hudson

  SSC Enthusiast

  Points: 195

  More actions

  March 12, 2019 at 10:38 am

  #371666

  I am trying to add a table to my database, but it says it already exists.
  I am using MSSMS and the script I am using is below:
  -- =========================================
-- Create table template
-- =========================================
USE Verses_Find
GO

  CREATE TABLE CSize
(
    CID INT IDENTITY(1,1) NOT NULL,
    BoxX Float NOT NULL,
    Cellw INT NOT NULL,
    Cellh INT NOT NULL,
    Size varchar(9) NOT NULL,
    floatx Float NOT NULL,
    floaty INT NOT NULL,
    floatw INT NOT NULL,
    floath INT NOT NULL,
    ort varchar(1) NOT NULL,
    Narative varchar(70) NOT NULL,
  CONSTRAINT CSize PRIMARY KEY (CID),
)
GO
  I have looked through every database on my server and there is no table that name.
  Whats causing this error?

• Jonathan AC Roberts

  SSCoach

  Points: 18356

  More actions

  March 12, 2019 at 10:42 am

  #2024242

  Your primary key constraint name is the same as your table name.
  Change it to: CONSTRAINT PK_CSize PRIMARY KEY (CID),