Default Constraint In SQL Server
DEFAULT constraint is used to insert a default value into a column ,that is predefined by us.
Query to create a DEFAULT constraint:-
1 | CREATE TABLE sales_order |
2 | ( |
3 | Id int NOT NULL, |
4 | O_No int NOT NULL, |
5 | OrderDate date DEFAULT GETDATE(),city varchar(50) |
6 | ) |
Create a default constraint in already created table:-
1 | ALTER TABLE sales_order |
2 | ALTER COLUMN City SET DEFAULT 'Delhi' |
Query for Droping Default constraint:-
1 | ALTER TABLE sales_order |
2 | ALTER COLUMN orderdate DROP DEFAULT |