多列如何添加主键,多列主键索引如何添加和修改
发布时间:2025/12/13 17:40:51 作者:Admin 阅读:15
广告:
多列如何添加主键,多列主键索引如何添加和修改
/****** Object: Table [DataFileResultTable2] Script Date: 2025/12/12 22:31:01 ******/
GO
CREATE TABLE [DataFileResultTable2](
[FileMngID] [varchar](32) NOT NULL,
[Version] [smallint] NOT NULL,
[ResultTableType] [smallint] NOT NULL,
[RowNo] [int] NOT NULL,
[ResultTableName] [nvarchar](64) NULL,
[Text1] [nvarchar](128) NULL,
[Text2] [nvarchar](128) NULL,
[Text3] [nvarchar](128) NULL,
[Text4] [nvarchar](128) NULL,
[Text5] [nvarchar](128) NULL,
[Text6] [nvarchar](64) NULL,
[Double100] [float] NULL,
CONSTRAINT [DataFileResultTable_pk] PRIMARY KEY CLUSTERED
(
[FileMngID] ASC,
[Version] ASC,
[ResultTableType] ASC,
[RowNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
这是一篇受密码保护的文章,请输入密码进行访问:
广告:
相关文章


