I know you can change the default value of an existing column like this: But according to this my query supposed to work: So here I’m trying to make my column Not Null and also set the Default value. But getting Incoorect Syntax Error near CONSTRAINT. Am I missing sth? Answer I think issue here is with the confusion between