SQL Check Constraints

Advertisements
Foreign Key Constaint in SQL Unique Constraint in SQL

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
DML Command in SQL SQL Select Unique
Insert Command in SQL Alter Command in SQL
Drop Command in SQL Update Command in SQL
Foreign Key Constaint in SQL Unique Constraint in SQL
Google Advertisment

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements