Add Default value constraint : Default Value « Constraints « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Constraints
3. Default Value

Add Default value constraint

 


7>    CREATE TABLE Customers
8>    (
9>       CustomerNo     int     IDENTITY   NOT NULL
10>          PRIMARY KEY,
11>       CustomerName   varchar(30)        NOT NULL,
12>       Address1       varchar(30)        NOT NULL,
13>       Address2       varchar(30)        NOT NULL,
14>      City            varchar(20)        NOT NULL,
15>      State           char(2)            NOT NULL,
16>      Zip             varchar(10)        NOT NULL,
17>      Contact         varchar(25)        NOT NULL,
18>      Phone           char(15)           NOT NULL,
19>      FedIDNo         varchar(9)         NOT NULL,
20>      DateInSystem    smalldatetime      NOT NULL
21>    )
22>    GO
1>
2>    ALTER TABLE Customers
3>       ADD CONSTRAINT CN_CustomerAddress
4>          DEFAULT 'UNKNOWN' FOR Address1
5> GO
1>
2> drop table Customers;
3> GO
1>
2>

 

Related examples in the same category