SQL Server创建表给出错误，该对象''已经存在，当它不

Question

对不起，如果这看起来像重复，但我无法找到我的情况的答案。我正在试图在数据库NBFP中创建表cardissuedates。

这里是我创建语句：

USE NBFoodPantry 

CREATE TABLE cardissuedates 
(
    clientid char(36) NOT NULL, 
    issuedate date NOT NULL 

    CONSTRAINT cardissuedates 
     PRIMARY KEY CLUSTERED (clientid ASC) 
      WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
       IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
       ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] 
) ON [PRIMARY] 

我得到这个错误：

Msg 2714, Level 16, State 5, Line 33
There is already an object named 'cardissuedates' in the database.

Msg 1750, Level 16, State 0, Line 33
Could not create constraint or index. See previous errors.

表没有在NBFB数据库存在，我无法找到它，当我检查主机和NBFB。

我已经试过

select * 
from sys.all_objects 
where name like '%ca%' 
order by 1 

select * 
from sys.tables 
where name like 'c%' 
order by 1 

select * 
from sys.all_columns 
where name like 'c%' 
order by 1 

我甚至创造了一个新的数据库，并执行该创建语句，随着使用的语句新的数据库名称。同样的错误。

我已经停止退出SSMS的所有服务。似乎没有任何工作。 我不知道在哪里再看。

任何帮助将非常感激。

感谢

Answer 1

你给主键相同的名称表，这是不允许的都是架构范围内的对象和多个对象不能有相同的schema_name.object_name。你可以这样做，而不是：

CREATE TABLE cardissuedates ( 
    clientid char(36) NOT NULL, 
    issuedate date NOT NULL CONSTRAINT 
    pk_cardissuedates PRIMARY KEY CLUSTERED (clientid ASC) 
    WITH (
     PAD_INDEX = OFF, 
     STATISTICS_NORECOMPUTE = OFF, 
     IGNORE_DUP_KEY = OFF, 
     ALLOW_ROW_LOCKS = ON, 
     ALLOW_PAGE_LOCKS = ON, 
     FILLFACTOR = 90 
    ) ON [PRIMARY] 
) ON [PRIMARY] 

我刚添加的前缀PK_到