Foreign key Constraint - English

194 visits



Outline:

What is a Foreign key? Foreign key link between students and department table Create a parent table department Alter table command Add a new column to the existing students table How to add a Foreign key using Alter table command Foreign key violation error Advantages of using Foreign key Alter table alter column command Commonly used constraints