How do I make a composite key with SQL Server Management Studio? November 27, 2022 by Tarik 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
