ALTER TABLE [dbo].[Users]DROP CONSTRAINT PK_UsersGOALTER TABLE [dbo].[Users]ALTER COLUMN [UserID] INT NOT NULLGOALTER TABLE [dbo].[Users]ADD CONSTRAINT [PK_Users] PRIMARY KEY ( [UserID] )GO