SQL Check Constraints


Prev Tutorial Next Tutorial

SQL Check Constraints

Check Constraints does not allow the values which are not satisfied the given condition. You can apply Check constraints on more than one column in same table. Check constraints allows to enter null values.

Example

	
create table employee
(eid number(3),
ename varchar2(15),
sal number(5) check (sal>50000));

Employee table

In below table you can enter salary more than 50000

emp_idnamesalary
101Amit74000
102Rahul84000
103Sultan54000
104Gaurav60000
105Hitesh95000

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements