Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-07 : 09:18:09
|
Douglas writes "If I where to define a primary key using multiple columns, can a column in the primary key have a repeating value in more than one row?
eg.
COL_1 | COL_2 | COL_3
-------------------------------
1 | 1 |1
2 | 1 |1
are these valid if my primary key consisted of (COL_1, COL_2, COL_2)?
or would COL_2 and COL_3 be illegel because of multiple 1's?
is this the same for unique groups?" |
|
|
|
|
|
multi column primary keys