修改数据库表主键类型

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]