如何在 SQL Server 2008 中创建复合主键
问题描述:
我想在 SQL Server 2008 中创建表,但我不知道如何创建复合主键.我怎样才能做到这一点?
I want to create tables in SQL Server 2008, but I don't know how to create composite primary key. How can I achieve this?
答
create table my_table (
column_a integer not null,
column_b integer not null,
column_c varchar(50),
primary key (column_a, column_b)
);