22,210
社区成员
发帖
与我相关
我的任务
分享
ALTER database SampleDB
ADD FILEGROUP SampleDBGrp1
ALTER database SampleDB
ADD FILE
(
NAME= 'SampleDBGrpFile1',
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\SampleDBGrpFile1.ndf'
)
TO FILEGROUP SampleDBGrp1;
ALTER TABLE [dbo].[Tab1] DROP CONSTRAINT [PK_Tab1] --删除聚集索引主健
GO
ALTER TABLE [dbo].[Tab1] ADD CONSTRAINT [PK_Tab1] PRIMARY KEY CLUSTERED
(
[ID] ASC
) ON SampleDBGrp1--定义存放文件组;
GO