How do I make a composite key with SQL Server Management Studio?

sql sql-server tsql ssms key

mrblah · Oct 9, 2009 · Viewed 172.9k times · Source

I want two INT columns to form the identity (unique) for a table

Answer

enter image description here

Open the design table tab
Highlight your two INT fields (Ctrl/Shift+click on the grey blocks in the very first column)
Right click -> Set primary key