Primary and Foreign Key in SQL

Question

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)classNamenoOfseats tbl_Division:divisionId(PK)divisionNameclassId(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?

Jai tripathi · Answer

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 Akhtar · Answer

Find below the sample SQL Script to insert class id as foreign key insert into tbl_Class(classNamenoOfseats) values('10th'50) declare @classId numeric set @classId=@@IDENTITY INSERT INTO tbl_Division: (divisionNameclassId) VALUES('divisionName'@classId)