TiltingCode
Programmer
I'm trying to create a table in SQL 2005 and I want to allow duplicate keya but the Ignore Duplicate Keys is disabled. I've tried re-creating the table but that does no good.
Please help.
Please help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Duplicate Keys
- Thread starter TiltingCode
- Start date
- Status
Can you explain what exactly do you want to create? If this field is a Primary Key, it doesn't allow duplicates by its definition.
PluralSight Learning Library
PluralSight Learning Library
- Thread starter
- #3
TiltingCode
Programmer
It appears I'll have to add another field then? My goal was to have the table consisting of a many to one relationship with another table.
No, that's fine. For foreign keys you should be able to have duplicates. Just define the relationship between primary table and this one.
PluralSight Learning Library
PluralSight Learning Library
- Status
Similar threads
- Locked
- Question