Cascade| Set Null | Set Default with DELETE & UPDATE

[@suyash7450]

Now my concept of using foreign key has been cleared completely.... thanks for explaining in detail.

[@lotusamaze1142]

Thanks

[@jamessoy9616]

Thank you for this video.

[@lotusamaze1142]

Glad it was helpful!

[@thulasiraju7713]

Sir why you taken foreign key(cust_id)

[@lotusamaze1142]

for creating relationship in two or more tables, atleast one table must have primary key in my case it is cust_id. Other tables must have the at least one column with same data type(name could be different) i.e cust_Id or customer_id or c_id as foreign key

[@satyaprakashjha19]

while updating the data in parent table i got an error "Cannot update identity column 'Hid'." should i drop the identity keyword? or there is any alternative!

[@lotusamaze1142]

Disallow insert into identity field SET IDENTITY_INSERT tablename OFF

[@sampath730]

Good

[@lotusamaze1142]

Thanks

[@earthscience4812]

GOOD

[@lotusamaze1142]

Thanks

[@VIPINKUMAR-kb1ru]

🙏🙏🙏🙏🙏🙏🙏

[@lotusamaze1142]

Thanks