Call multiple Foreign key in a table

Question

Sir I am doing program of 4 tables in SQL at the moment. Abb:-Primary Key(P.K) My tables are:- tbl_Student(P.K.studentId) tbl_Subject(P.K.subjectId) tbl_Division(P.K.divisionId) and tbl_Mark(markId). I want studentId subjectId and divisionId in tbl_Mark as foreign key. pls provide the query.

Sandeep Singh Shekhawat · Answer

ALTER TABLE tbl_Mark ADD CONSTRAINT FK_tbl_Mark_studentId Foreign key ( studentId ) References tbl_Student ( studentId ) ALTER TABLE tbl_Mark ADD CONSTRAINT FK_tbl_Mark_subjectId Foreign key ( subjectId ) References tbl_Subject ( subjectId ) ALTER TABLE tbl_Mark ADD CONSTRAINT FK_tbl_Mark_divisionId Foreign key ( divisionId ) References tbl_Division ( divisionId )

Bineesh VP · Answer

Thank You Mr.sandeep Singh for the correct answer.