Constraint Validation in SQL

24/05/2011 13:32

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