Primary Keys are one of the most important aspects of good database design.
Primary Key Properties
- May never be null
- One primary key per table
- Cannot be modified to a new value
Most of what you will find about Primary Keys will pertain to most or all database platforms, but there may be some minor differences in how they are implemented and how they behave on disk.
There is a lot of information on the internet about Primary Keys. A quick search will turn up thousands of articles, examples, blog posts, forums and question/answer threads.
Here are a few we like, but feel free to continue the search:
The Wikipedia page for Primary Keys actually redirects to a larger page on Unique Keys.
You need to sign up for Treehouse in order to download course files.Sign up