how to make a non-unique primary key?

Answer 1

You cannot make a non-unique primary key. Primary keys are, by definition, unique.

Answer 2

I think U can't do that... Primary keys should be unique 'cause that's the way to identify a row... If a primary key were non-unique you'd have problems to find rows. Find a column you can make unique, and use it as primary key, or try using an index as primary key.

Answer 3

You probablu need to make a different cilomn your primary key. Create a new column as an identity, autinum, whatever your db calls it, and remove the primary key from the column that you need to make non-unique.

Primary keys are by definition, unique.

Answer 4

That's generally an anti-good thing and not allowed.

I think what you want is a unique primary key and another index that allows dups.

in general you don't want dup rows in a db.

Answer 5

Allow Duplicates