引用表'UserLogin'中没有主键或候选键与外键'FK__CardDetai__Email__173876EA'中的引用列列表匹配。 [英] There are no primary or candidate keys in the referenced table 'UserLogin' that match the referencing column list in the foreign key 'FK__CardDetai__Email__173876EA'.

问题描述

您好，



当我们创建外键时，我正在使用此查询创建表和约束螺母，它正在收到错误： -

Hello,

I am using this query for create table and constraint nut when we creating foreign key it's getting error:-

create table UserLogin(UserID bigint identity(1,1),
UserFirstName nvarchar(30),
UsrerLastName nvarchar(30),
PhoneNumber nvarchar(10) not null,
EmailId nvarchar(100) not null,
Password nvarchar(10),
CompanyName nvarchar(30),
Profession nvarchar(30),
State nvarchar(20),
City nvarchar(20),
Pincode int,
FbLike int,
DailyFreeCard int,
LoginDate datetime,
CampaignName nvarchar(30),
BAL int,
AccountType nvarchar(20))

ALTER TABLE UserLogin
ADD CONSTRAINT PK_UserLogin
PRIMARY KEY(EmailId, PhoneNumber)

create table CardDetails(CardID bigint,
CardCategory nvarchar(30),
CardName nvarchar(20),
RecFirstName nvarchar(30),
CardBody nvarchar(max),
EmailId nvarchar(100) FOREIGN KEY (EmailId) REFERENCES UserLogin(EmailId),
SenderFirstName nvarchar(30),
ImagePath nvarchar(max),
CardCost nvarchar(max))

ALTER TABLE CardDetails
ADD FOREIGN KEY (EmailId)
REFERENCES UserLogin(EmailId) 

错误： - 引用表'UserLogin'中没有主键或候选键与外键'FK__CardDetai__Email__173876EA'中的引用列列表匹配。



请帮助我如何解决这个问题？



提前进行。



Ankit Agarwal

软件工程师

Error:- There are no primary or candidate keys in the referenced table 'UserLogin' that match the referencing column list in the foreign key 'FK__CardDetai__Email__173876EA'.

Please help me how can we resolve this problem?

Thnaks in Advance.

Ankit Agarwal
Software Engineer

推荐答案

你的桌子CardDetails没有有身份ID或p rimary key。

Your table CardDetails does not have an identity id or primary key.

您需要将UserLogin.EmailId声明为主键或至少作为唯一键

You need to declare UserLogin.EmailId either as primary or at least as a unique key

这篇关于引用表'UserLogin'中没有主键或候选键与外键'FK__CardDetai__Email__173876EA'中的引用列列表匹配。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！