PRIMARY KEY | FOREIGN KEY |
---|---|
A table can have only one Primary Key | A table can have more than one Foreign Key |
Primary key can not have NULL values | Foreign key can have NULL values |
Primary Key can not have duplicate values | Foreign key can have duplicate values |
Primary key can be defined independently | Foreign key can not be defined independently |