ALTER TABLE Orders
ADD CONSTRAINT fk_PerOrders
FOREIGN KEY (P_Id)
REFERENCES Persons(P_Id)
FOREIGN KEY (P_Id)
REFERENCES Persons(P_Id)
削除:
ALTER TABLE Orders
DROP FOREIGN KEY fk_PerOrders
DROP FOREIGN KEY fk_PerOrders
http://www.w3schools.com/sql/sql_foreignkey.asp
0 件のコメント:
コメントを投稿