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

Question

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

User · Answer

In design mode  right click table select modify  highlight both columns right click and choose set primary key

User · Answer

create table my table       id part1 int not null      id part2 int not null      primary key  id part1  id part2

User · Answer

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

User · Answer

here is some code to do it   -- Sample Table create table myTable        Column1 int not null      Column2 int not null   GO  -- Add Constraint ALTER TABLE myTable     ADD CONSTRAINT pk myConstraint PRIMARY KEY  Column1 Column2  GO   I added the constraint as a separate statement because I presume your table has already been created

User · Answer

create table myTable        Column1 int not null      Column2 int not null   GO   ALTER TABLE myTable     ADD  PRIMARY KEY  Column1 Column2  GO

User · Answer

Highlight both rows in the table design view and click on the key icon  they will now be a composite primary key     I m not sure of your question  but only one column per table may be an IDENTITY column  not both

User · Answer

Open up the table designer in SQL Server Management Studio  right-click table and select  Design    Holding down the Ctrl key highlight two or more columns in the left hand table margin  Hit the little  Key  on the standard menu bar at the top  You re done     -

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

Examples related to sql

Examples related to sql-server

Examples related to tsql

Examples related to ssms

Examples related to key