CHECK Constraints for current date : Check value range « Constraints « SQL Server / T-SQL

1. SQL Server / T-SQL
2. Constraints
3. Check value range

CHECK Constraints for current date

 

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

 

Related examples in the same category