Primary Key

A Primary Key is a unique identifier that identifies each record in a table uniquely. There can be no null values. There can only be 1 primary key per table. A primary key automatically creates a unique clustered index, more on this later.