[SQL Server] Create constraints using ALTER TABLE

Create Default Constraint:
ALTER TABLE <TableName>
ADD CONSTRAINT [<constraint_name>] DEFAULT (<default_Value>) FOR <Column_name>

Create a PRIMARY KEY Constraint:
ALTER TABLE <Table_name>
ADD CONSTRAINT [PK_Constraint_name] PRIMARY KEY (PK_Column_name)