alter table tableName drop CONSTRAINT PK_tableName
go
ALTER TABLE [dbo].[tableName] ADD CONSTRAINT [PK_tableName] PRIMARY KEY CLUSTERED
(
id asc,[addTime] ASC
)
ON datetime_scheme(addTime)
GO
直接将普通表改为分区表
最新推荐文章于 2024-06-10 20:10:19 发布
alter table tableName drop CONSTRAINT PK_tableName
go
ALTER TABLE [dbo].[tableName] ADD CONSTRAINT [PK_tableName] PRIMARY KEY CLUSTERED
(
id asc,[addTime] ASC
)
ON datetime_scheme(addTime)
GO