Alter table query to change identity column from int to bigint in sql2019 server

Question

Post reply

Alter table query to change identity column from int to bigint in sql2019 server

sachinleo78

SSC Enthusiast

Points: 195
More actions
February 20, 2024 at 8:40 am

#4381573

Alter table query to change identity column from int to bigint in sql2019 server

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247172 More actions · Answer 1

sachinleo78 wrote:

Alter table query to change identity column from int to bigint in sql2019 server

What is your question?

sachinleo78 SSC Enthusiast Points: 195 More actions · Answer 2

have a large Table having Identity column as Int and value has neared the max value so need to make the identity column as BigInt

Phil Parkin SSC Guru Points: 247172 More actions · Answer 3

Is it so difficult for you to ask a question?

Can anyone provide the T-SQL code I need to amend an identity column from INT to BIGINT, please?

I am guessing that this is what you are asking. If not, what are you hoping for?

sachinleo78 SSC Enthusiast Points: 195 More actions · Answer 4

sachinleo78

SSC Enthusiast

Points: 195

February 20, 2024 at 9:22 am

#4381596

Yes

Phil Parkin SSC Guru Points: 247172 More actions · Answer 5

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    SomeId INT IDENTITY(1, 1)
   ,SomeText VARCHAR(10)
   ,CONSTRAINT PK_Nonsense
        PRIMARY KEY CLUSTERED(SomeId)
);

ALTER TABLE #SomeData DROP CONSTRAINT IF EXISTS PK_Nonsense;

ALTER TABLE #SomeData ALTER COLUMN SomeId BIGINT;

ALTER TABLE #SomeData ADD CONSTRAINT PK_Nonsense PRIMARY KEY(SomeId);

sachinleo78 SSC Enthusiast Points: 195 More actions · Answer 6

sachinleo78

SSC Enthusiast

Points: 195

February 20, 2024 at 9:36 am

#4381615

Thanks Phil

Alter table query to change identity column from int to bigint in sql2019 server

Cookies on SQLServerCentral