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 |
|
majnoon
Starting Member
26 Posts |
 Posted - 2003-01-14 : 11:14:45
|
| Hi:I have an ORACLE database feeding a SQL2K database. The ORACLE database creates a ROWID field by default. This field has binary unique data, but the data is duplicated with regards to characters. I would like to set this field as a primary key. Is there a way to get SQL2K allow this binary unique field as the primary key.Wishing you a peaceful journey |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-14 : 11:30:12
|
| Yes, you can place a primary key constraint on a column of data type binary.I would suggest you search this site for debate on natural vs. surrogate primary keys.Jay White{0} |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-14 : 12:23:08
|
quote:
I would suggest you search this site for debate on natural vs. surrogate primary keys.
He/she is in for a lot of reading.  |
|
|
|
majnoon
Starting Member
26 Posts |
Posted - 2003-01-20 : 10:54:31
|
| He thanks you very muchWishing you a peaceful journey |
|
|
|
|
|
|
Primary Key