how to set foriegnkey

Question

Hii...plz help me how to set foriegn key.I have two table named "TB_Employee" and "TB_EmployeeId" in that i have one column "TagId" which i want to set as foriegn key.

Shankey · Answer

Hi shivaraj, Hope this is in sql server then do following to create fk in TB_EmployeeId Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} ALTER TABLE TB_EmployeeId ADD CONSTRAINT fk_TagID FOREIGN KEY( TagId ) REFERENCES TB_Employee ( TagId )

Manikavelu Velayutham · Answer

The structure of these two tables will be as follows: Table CUSTOMER column name characteristic SID Primary Key Last_Name First_Name Table ORDERS column name characteristic Order_ID Primary Key Order_Date Customer_SID Foreign Key Amount CREATE TABLE ORDERS (Order_ID integer primary key, Order_Date datetime, Customer_SID integer references CUSTOMER(SID), Amount double); ALTER TABLE ORDERS ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID);