创建表主键非聚集及聚集索引

USE [DBName]
GO

CREATE TABLE [dbo].[projectModify](
[id] [BIGINT] IDENTITY(1,1) NOT NULL,
[busId] [UNIQUEIDENTIFIER] NOT NULL,
[AddDate] [DATETIME] NOT NULL,
CONSTRAINT [PK_projectModify] PRIMARY KEY NONCLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

 

USE [DBName]
GO

CREATE CLUSTERED INDEX [IDX_syn_projectModify_AddDate] ON [dbo].[projectModify]
(
[AddDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO