How can I create a Table in SQL Server that has a Primary Key and a Foreign Key, but the Primary Key data should be repeated?
For example:
PK FK
1 100
2 100
1 200
3 100
4 200
4 100
4 300
Asked
Active
Viewed 542 times
-14
Juan Carlos Oropeza
- 45,789
- 11
- 74
- 113
bhanu prakash
- 27
- 1
- 6
-
3Edit your question. Don't use caps-lock. Move question from title to body etc. – jarlh Nov 18 '15 at 14:11
-
1You can't. As Jaco said, *by definition*, a primary key is unique. – Lynn Crumbling Nov 18 '15 at 14:13
-
The primary key cannot be repeated. Create another primary key (id) column. – Jonathon Reinhart Nov 18 '15 at 14:14
-
3I'm voting to close this question as off-topic because the question is unanswerable. – Lynn Crumbling Nov 18 '15 at 14:14
-
2@LynnCrumbling The question is certainly answerable. The answer is "You can't." – Siyual Nov 18 '15 at 14:15
-
1Just create a composite primary key, check here http://stackoverflow.com/a/3922359/3470178 – Juan Carlos Oropeza Nov 18 '15 at 14:18
1 Answers
4
A primary key is unique by definition, you can't have repeated values for your primary key column(s).
Alex
- 20,287
- 10
- 59
- 69
-
-
@bhanuprakash STOP SHOUTING AT US. If you want to insert data like that, either don't constrain it, or make it a compound key. – Siyual Nov 18 '15 at 14:18
-
3
-
-