How to create composite primary key in SQL Server 2008

Question

I want to create tables in SQL Server 2008, but I don't know how to create a composite primary key. How can I achieve this?

Answer 1

Try using the below code:

create table my_table (

     column_a integer not null,

     column_b integer not null,

     column_c varchar(50),

     primary key (column_a, column_b)

);