Answers for "create table with default constraint in sql server"

default number in sql

//Sql Server

//Add a table 
ALTER TABLE clients ADD Points INT DEFAULT 0
//Edit an existing table
ALTER TABLE clients ADD CONSTRAINT points DEFAULT 0 FOR Points

default constraint in ms sql

/*Alter an existing column to add a default constraint*/
ALTER TABLE (Table_Name)
ADD CONSTRAINT (Constraint_Name)
DEFAULT (Default_Value) FOR (Existing_Column_Name)

default constraint in ms sql

/*Adding a New Column, with default value to an existing table*/
ALTER TABLE (Table_Name)
ADD (Column_Name)(Data_Type) (Null/NOT NULL)
CONSTRAINT (Constraint_Name) DEFAULT (Default_Value)