Home
> Sql Server > SQL: Alter script to change the Primarykey Column datatype
SQL: Alter script to change the Primarykey Column datatype
–This will drop the primary key constraint
ALTER TABLE [pTARGET_TYPE] DROP CONSTRAINT PK_TARGET_TYPE
–Alter datatype
ALTER TABLE [TARGET_TYPE] ALTER COLUMN [TARGET_TYPE_ID] INT NOT NULL
–Add Primary key constraint
ALTER TABLE [TARGET_TYPE] ADD CONSTRAINT PK_TARGET_TYPE PRIMARY KEY ([TARGET_TYPE_ID])
Advertisements
Categories: Sql Server
alter, alter column, change datatype, datatype, error, issue, pk, primary key, rahul bhatia, script, Solution, SQL, SQL Server
Comments (0)
Trackbacks (0)
Leave a comment
Trackback
Advertisements
Rahul Bhatia
Rahul Bhatia
Advertisements
Comments