How do I make a composite key with SQL Server Management Studio?
key, sql, sql-server, ssms, t-sql
Solution
- 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
Problem
How do I make a composite key with SQL Server Management Studio? I want two INT columns to form the identity (unique) for a table