Constraint Validation in SQL
CREATE TABLE Ex_Check
(
cust_id int CONSTRAINT CN_PKEY PRIMARY KEY,
cust_name char(50),
cust_address char(50) CONSTRAINT ntnull NOT NULL,
cust_credit_limit money CONSTRAINT chk_limit CHECK (cust_credit_limit < 5000 ),
Gender char(10) CONSTRAINT chk_Gender CHECK (Gender in ('Male','Female'))
)
insert into ex_Check
(
cust_id,cust_name,cust_credit_limit,Gender
)
values
(
115,'deva',4000,'Male'
)
insert into ex_Check values(104,'Shank','Namakkal',4000,'male')
insert into ex_Check values(103,'Shankar','chenni',2000,'male')
select * from Ex_Check