--TO CHANGE DEFAULT VALUE OF SUMMONER Use Muonline GO ALTER TABLE dbo.AccountCharacter DROP CONSTRAINT DF_AccountCharacter_Summoner GO ALTER TABLE dbo.AccountCharacter ADD CONSTRAINT DF_AccountCharacter_Summoner DEFAULT 1 FOR Summoner GO --TO UPDATE ALL ACCOUNTS TO NEW VALUE THAT ACCOUNTS CAN CREATE SUMMONER BEFORE THAT update AccountCharacter set Summoner = 1