mysql主键数据类型更改_修改数据库表主键类型

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]