8. SQL Statements : CREATE INTEGRITY : CREATE INTEGRITY Examples
 
Share this page                  
CREATE INTEGRITY Examples
1. Make sure that the salaries of all employees are no less than 6000.
CREATE INTEGRITY ON employee IS salary >= 6000;
2. In an embedded application, define an integrity using a host language variable.
EXEC SQL CREATE INTEGRITY ON employee
    IS sal < :sal_limit;