Search code examples
sqldatabase-designprimary-keynormalization

Is it OK not to use a Primary Key When I don't Need one

If I don't need a primary key should I not add one to the database?

Solution

  • A primary key uniquely identifies a row in your table.

    The fact it's indexed and/or clustered is a physical implementation issue and unrelated to the logical design.

    You need one for the table to make sense.