ÇëÎÊ´´½¨Íâ¼üµÄsqlÓï¾ä

Sys_Employee±í
eid  ePosition

Sys_DicPosition±í
id  PositionName

alter table Sys_Employee
add constraint
foreign key(ePosition) references Sys_DicPosition(id)

ÎҵĴúÂëÈçÉÏ£¬Ìáʾforeign¸½½üÓï·¨´íÎó£¬ÇëÎÊÔõô¸Ä£¿

---

alter table Sys_Employee
add constraint fk_id-- ¼ÓÒ»¸öÔ¼ÊøÃû
foreign key(ePosition) references Sys_DicPosition(id)

---

SQL code:
alter table Sys_Employee
add constraint FK_ePosition
foreign key(ePosition) references Sys_DicPosition(id)

---

alter table Sys_Employee
add constraint FK_ePosition-¼Ó¸öÔ¼ÊøÃû
foreign key(ePosition) references Sys_DicPosition(id)

---

alter table Sys_Employee
add constraint Ô¼ÊøÃû_NAME
foreign key(ePosition) references Sys_DicPosition(id)

< table_constraint > ::=
  [ CONSTRAINT constraint_name ]
    { [ { PRIMARY KEY | UNIQUE }
        [ CLUSTERED | NONCLUSTERED ]
        { ( column [ ,...n ] ) }
        [ WITH FILLFACTOR = fillfactor ]
        [ ON { filegroup | DEFAULT } ]
        ]
        |    FOREIGN KEY
        &