错误SQL04111:Visual Studio 2010数据库项目
|
我在Visual Studio 2010数据库项目的表中创建了一个关系,但出现此错误:
Error SQL04111: The referenced table \'[dbo].[tblAccount]\' contains no primary or candidate keys that match the referencing column list in the foreign key. If the referenced column is a computed column, it should be persisted.
这是外键:
ALTER TABLE [dbo].[tblDispute]
ADD CONSTRAINT [FK_AccountNo]
FOREIGN KEY (AccountNo)
REFERENCES tblAccount ([Account No]) ON DELETE NO ACTION ON UPDATE CASCADE;
我该如何解决?
没有找到相关结果
已邀请:
1 个回复
凰葱崎济邯