多列如何添加主鍵，多列主鍵索引如何添加和修改
發(fā)布時間：2025/12/13 17:40:51 作者：Admin 閱讀：37
廣告：
多列如何添加主鍵，多列主鍵索引如何添加和修改
/****** 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
這是一篇受密碼保護的文章，請輸入密碼進行訪問：
廣告：
相關(guān)文章
