Primary Key dan Foreign Key

Perbedaan  Primary Key dan Foreign Key seperti dalam tabel berikut :

 

    --Buat  Parent Table
    CREATE TABLE Department
     (
     DeptID int PRIMARY KEY, --define primary key
     Name varchar (50) NOT NULL,
     Address varchar(100) NULL
    )
     GO 

     --Buat Child Table
    CREATE TABLE Employee
     (
     EmpID int PRIMARY KEY, --define primary key
     Name varchar (50) NOT NULL,
     Salary int NULL,
     --define foreign key
     DeptID int FOREIGN KEY REFERENCES Department(DeptID)
     ) 



Source : http://www.dotnet-tricks.com/Tutorial/sqlserver/TENc260912-Difference-between-Primary-Key-and-Foreign-Key.html