CREATE TABLE #Temp_Actor
(
ActorId INT IDENTITY (1,1) NOT NULL
);
INSERT INTO #Temp_Actor DEFAULT VALUES;
INSERT INTO #Temp_Actor DEFAULT VALUES;
INSERT INTO #Temp_Actor DEFAULT VALUES;
CREATE TABLE #Temp_ThirdParty
(
ThirdPartyActorId INT NOT NULL,
CONSTRAINT PK_ThirdPartyActorId
PRIMARY KEY (ThirdPartyActorId),
CONSTRAINT FK_ThirdPartyActorId_ActorId
FOREIGN KEY (ThirdPartyActorId) REFERENCES #Temp_Actor (ActorId)
)
我收到一個錯誤：
參考的表“#TempActor”中沒有主鍵或候選鍵
肯定ActorId是主鍵？！
uj5u.com熱心網友回復：
看看下面。
缺失的部分在這里：
ActorId INT IDENTITY (1,1) PRIMARY KEY)
SQL
USE tempdb;
GO
DROP TABLE IF EXISTS #Temp_Actor;
DROP TABLE IF EXISTS #Temp_ThirdParty;
CREATE TABLE #Temp_Actor (ActorId INT IDENTITY (1,1) PRIMARY KEY);
INSERT INTO #Temp_Actor Default values;
INSERT INTO #Temp_Actor Default values;
INSERT INTO #Temp_Actor Default values;
Create TABLE #Temp_ThirdParty (ThirdPartyActorId INT NOT NULL
, CONSTRAINT PK_ThirdPartyActorId PRIMARY KEY (ThirdPartyActorId)
, CONSTRAINT FK_ThirdPartyActorId_ActorId FOREIGN KEY (ThirdPartyActorId) REFERENCES #Temp_Actor(ActorId));
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/340098.html
標籤：sql-server
上一篇：將多列轉換為單列