SQL Azure唯一的非聚集约束



SQL Azure是否支持唯一的非集群约束?类似的东西:

CREATE TABLE [dbo].[MyTable] (
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [FieldA] [nvarchar](50) NULL,
    [FieldB] [nvarchar](50) NULL,
    [FieldC] [int] NULL,
CONSTRAINT [PK_Id] PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [UQ_ABC] UNIQUE NONCLUSTERED ([FieldA], [FieldB], [FieldC])

如果这让您感到困扰,则在上面的语句中缺少(在结束之间)

最新更新