Two Fields - One Primary Key

[Onyxpurr]

I thought in SQL Server 97 that I can create a primary key with two fields?

Please let me know if this is correct. My DBA is saying no.

Thanks!!

 

[swampBoogie]

A primary key constraint can contain more than one column, so you are correct.

 

[Malchik]

Hi, well you can with SQL 2000 and if I remember correcly you was able to do it in SQL 6.5, so there is no reason you can't do it in the version 7.



Mal'chik

 

[Onyxpurr]

Thank you!

 

[SQLSister]

However, just because you can do it doesn't mean you should do it. It is often better performance wise to use an identity column as the proimary key and put a cunique constraint onthe two fields in combination. Takes less storage space for the foreign keys and joins on number fields are much faster.

 

[Onyxpurr]

Thank you.

I went researching after seeing responses and put a request into my dba for the following:

CONSTRAINT table_key PRIMARY KEY (a, b)

Is that right?