DATABASE – Natural Primary Keys

A Natural Primary Key is a column of values in your existing data that is guaranteed to be unique for every row.

Natural Key Pitfalls

Watch out for columns that appear to hold unique values simply because they contain only a few rows.

Only choose a natural key column if it is impossible to have duplicates, not merely improbable.

Leave a Reply

Your email address will not be published. Required fields are marked *