how to add foreign key constraint, SQL Server

Question

hi guys, I have a registration table with primary key RegId. I have another table named Users, also contain RegId as Foreign key.

When I delete one RegId from registration, I have to delete RegId from Users. Can anybody help?

Answer 1

Define the foreign key with "ON DELETE CASCADE".

You can do this is in T-SQL or in design view in SSMS