How to create compound primary key in sql server

Today, I will talk to you about how to create a compound primary key in sql server. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Create a compound primary key:

Method 1:

After the table is created, alter table table_name add primary key (field 1, field 2)

Method 2:

CREATE TABLE table name (field name 1 Int Not Null, field name 2 nvarchar (13) Not Null field name 3. Field name N.) GO ALTER TABLE table name WITH NOCHECK ADD CONSTRAINT [PK_ table name] PRIMARY KEY NONCLUSTERED ([field name 1], [field name 2]) GO

After reading the above, do you have any further understanding of how to create a compound primary key in sql server? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.