Answers for "how to set default constraint for creating table in sql"

SQL
0

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)
Posted by: Guest on June-08-2021
0

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)
Posted by: Guest on June-08-2021

Code answers related to "how to set default constraint for creating table in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language