question regarding primary key | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

question regarding primary key

Hi,
I had question regarding my table which has netid, last name, first name information. can someone suggest me if it’s ok to set primary key on netid column?
If thats all the information youre willing to supply us with, I recommend consulting the magic 8 ball <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />
If netid is able to uniquely identify each row in your table it looks like a good candidate for the Primary Key. But I agree with Chappy in that you’ve given us very few informations. [<img src=’/community/emoticons/emotion-5.gif’ alt=’;)‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
]]>