mariadb-columnstore-engine/dbcon/ddlpackage/sql/ct03.sql

-- Named check constraint
  CREATE TABLE STAFFz
  ( EMPNUM CHAR(3),
    SALARY DECIMAL(6) constraint salary CHECK (SALARY > 0));