What Is the Purpose of a Primary Key in a Database?

By Staff WriterLast Updated Mar 25, 2020 5:44:08 AM ET
David/Taxi/Getty Images

Primary keys are used to uniquely identify a row in a database table; no two rows can have the same primary key. Identification numbers are often used as primary keys. Any field that is not necessarily unique, such as a person's name, is not suitable for being a primary key.