Simple check constraint to ensure that no negative values are stored in the column salary

create table employees
(
   emp_id       integer not null primary key,
   last_name    varchar(100) not null,
   first_name   varchar(100),
   salary       numeric(12,2) not null check (salary >= 0)
);

Back to the SQL Feature Comparison