How to unique multiple column in SQL Server

Asked Apr 10 '18 at 04:07

Active Apr 10 '18 at 04:23

Viewed 37 times

I am working with SQL Server 2012 and I have one table that has 3 constraint primary key. I just want table structure like that =>

Combination of this 3 column must be unique

ColumnA  ColumnB ColumnC
1         2        3
1         2        4

But when I test this table, This table can accept duplicate data like that=>

ColumnA  ColumnB  ColumnC
1        2        3
1        2        3

Why can I add duplicate value like that even constraint primary key? or Am I misunderstanding about constraint primary?

edited Apr 10 '18 at 04:23

marc_s

asked Apr 10 '18 at 04:07

Loran

Looks like there is another column in the primary key. – cha Apr 10 '18 at 04:13
Follow the duplicate link for an answer. I couldn't say it any better myself. – Tim Biegeleisen Apr 10 '18 at 04:13
@cha, There is no primary key anymore. – Loran Apr 10 '18 at 04:25
Can you click on the Indexes button in your SSMS and double-check? – cha Apr 10 '18 at 04:33
Yep, I already check this. There is no other primary key. – Loran Apr 10 '18 at 05:33
Can you share the complete table script? It shouldn't allow duplicate values unless strings are being prefixed with white spaces. – Rajesh Bhat Apr 11 '18 at 07:02

0 Answers0