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)
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