SQL Server and BI Tools: How to change Primary Key From Int to BigInt

Showing posts with label How to change Primary Key From Int to BigInt. Show all posts

Wednesday, June 27, 2012

How to change Primary Key From Int to BigInt

ALTER TABLE [dbo].[TableName]
Drop CONSTRAINT PrimaryKeyConstraintName

--change data type
ALTER TABLE [dbo].[TableName]
ALTER COLUMN ColumnName BigInt

--add primary key
ALTER TABLE [dbo].[TableName]
ADD CONSTRAINT PrimaryKeyConstraintName PRIMARY KEY (ColumnName)