创建具有主键和唯一键的表

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

---

想要改进这个问题？通过编辑这篇文章添加详细信息并澄清问题。

10 年前已关闭。

Answer 1

这应该做到这一点。

CREATE TABLE [dbo].[TestTable]
(
    [id] [int] NOT NULL,
    [otherValue] [int] NOT NULL,
 CONSTRAINT [IX_OtherValye] UNIQUE NONCLUSTERED 
(
    [otherValue] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

Answer 2

CREATE TABLE [MyTable]
(
    ID INT NOT NULL,
    SomeUniqueColumn varchar(20) NOT NULL,

    CONSTRAINT PK_MyTable PRIMARY KEY(ID),
    CONSTRAINT U_MyTable UNIQUE(SomeUniqueColumn)
)