One way: ALTER TABLE [Name] Add [Add Field Name] [INT] Constraint Added Added Field Name Default Default NOT NULL Go
Another way:
ALTER TABLE Name Add Add Added Field Name INT Not Null Default (Default)
