Loading

Primary and Foreign Key in SQL

Bineesh Viswanath

13y1.5k

Sir, I am now in SQL training.

I have a doubt in the case of Primary and Foreign Key.

Look a Table:-

tbl_Class: classId(PK),className,noOfseats

tbl_Division:divisionId(PK),divisionName,classId(FK_tbl_Class)

In this table I set classId and divisionId as IDENTITY

when I do a Insert into procedure, I want to put same data the classId carry in tbl_Class.

is there any way to auto add the column like classId in the table where they act as FK?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jai tripathi13y ago
Understand it properly... The "tbl_Class" is a master table so it does not has any dependency on any thing.. so you can insert the records freely in that table... but table "tbl_division" has FK on "tbl_class" so each time you insert a record in this table, so have to insert one of the classid in your "tbl_division" table HTH
Riyaz Akhtar13y ago
Find below the sample SQL Script to insert class id as foreign key

insert into tbl_Class(className,noOfseats)
values('10th',50)
declare @classId numeric
set @classId=@@IDENTITY

INSERT INTO tbl_Division:
(divisionName,classId)
VALUES('divisionName',@classId)