SQL Reference Guide > SQL Reference Guide > SQL Statements > CREATE INTEGRITY > CREATE INTEGRITY Examples
Was this helpful?
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;
Last modified date: 01/30/2023