sql server - How can I make 2 fields in one primary key with SQL?

Question

OrderID and ProductID in my OrderID table, for example, act as a single primary key. I'm just not sure how to do this with SQL.

Example:

CREATE TABLE [Order Details]
(
[OrderID] [int] IDENTITY(1,1) NOT NULL,
[ProductID] [int] NOT NULL,
...
)

Can I simply add PRIMARY KEY to both lines after NOT NULL to make them both the primary key?

Answer 1

You need to declare the columns participating in the primary key at the end

CREATE TABLE [Order Details]
(
[OrderID] [int] NOT NULL,
[ProductID] [int] NOT NULL,
...,
PRIMARY KEY(OrderID, ProductID)
)