Monday 4 March 2013

Change FOREIGN KEY Reference in sql

try this sample way for

the
ALTER TABLE Dealpool ADD CONSTRAINT fk_Dealpool_Agent FOREIGN KEY (AgentId)

//It is a reference table column

REFERENCES Agent(AgentId) // It is a referring  table primary key


Below final code is .

ALTER TABLE Dealpool ADD CONSTRAINT fk_Dealpool_Agent FOREIGN KEY (AgentId)    REFERENCES Agent(AgentId)

No comments:

Post a Comment

If any doubt?then please comment in my post

How to reduce angular CLI build time

 Index: ----- I am using angular cli - 7 and I am going to tell how to reduce the build time as per my knowledge. Problem: -------- Now the ...