章术

导航

修改数据库表主键类型

use DBName;
GO

ALTER TABLE dailyTopicsReportLogCalc DROP constraint [PK_dailyTopicsReportLogCalc]

ALTER TABLE dailyTopicsReportLogCalc ALTER COLUMN sequenceNo BIGINT

ALTER TABLE dailyTopicsReportLogCalc ADD CONSTRAINT [PK_dailyTopicsReportLogCalc] PRIMARY KEY CLUSTERED
(
[sequenceNo] ASC,
[loggingDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


ALTER TABLE dailyTopicsReportLogTransaction DROP constraint [PK_dailyTopicsReportLogTransaction]

ALTER TABLE dailyTopicsReportLogTransaction ALTER COLUMN sequenceNo BIGINT

ALTER TABLE dailyTopicsReportLogTransaction ADD CONSTRAINT [PK_dailyTopicsReportLogTransaction] PRIMARY KEY CLUSTERED
(
[sequenceNo] ASC,
[loggingDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

 

posted on   章术  阅读(288)  评论(0编辑  收藏  举报

努力加载评论中...
点击右上角即可分享
微信分享提示