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]