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