修改数据库表主键类型
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]
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步