Junior — Middle
Is it possible to add a repeating record to a table that has a primary key?
sobes.tech AI
Answer from AI
In a database table where a primary key (PRIMARY KEY) is defined, you cannot add a duplicate record with the same key value. The primary key guarantees the uniqueness of each record, so attempting to insert a duplicate will result in a uniqueness violation error. For example, if you have a table with a field id as the primary key, each record must have a unique id value.