如何在表中使用两个主键 [英] how to use two primary keys in table

问题描述

如果在sql server的一个表中，它包含一个主键，我想再使用一个列作为主键。但是我们只能使用一个主键。如何实现这个

If In a table in sql server it is containing one primary key and I want to use one more column as primary key.but we can use only one primary key for a table.How should we achieve this

推荐答案

如果你想使用两列作为主键，那么使复合主键意味着将两列作为主键

if u want to use two column as primary key then make composite primary key means make two column as primary key

看一下下面显示如何创建复合主键的链接

在SQL Server中创建复合主键 [ ^ ]

如何在SQL Server 2008中创建复合主键 [ ^ ]

SQL Server添加主键 [ ^ ]

复合主键 [ ^ ]

Take a look at the below links that show how to create composite Primary keys
Creating composite primary key in SQL Server[^]
How to create composite primary key in SQL Server 2008[^]
SQL Server Add Primary Key[^]
Composite Primary Keys[^]

表中只能有一个主键。虽然，这并不意味着它应该只有一列。您可以使用两列作为主键。这是一个例子：

You can have only one primary key in a table. Although, this does not mean that it should be only one column. You can use two columns as primary key. Here''s an example:

CREATE TABLE SampleTable (
  Key1 integer,
  Key2 integer,
  SomeOtherColumn nvarchar
  primary key (key1, key2)
);

您可能还需要考虑唯一约束。

这篇关于如何在表中使用两个主键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！