CHECK constraint between columns

Question

Hi I am trying to use the CHECK constraint to stop one row from being larger than the other.

create table myTable (
begin int(10),
end int(10),
check (begin < end)
);

The table is created however there is no constraint being applied when inserting rows.

Any help on what I'm doing wrong would be great.

is this in SQL Server? I'm just quite unsure how'd you successfullly created the table with int(10). Anyway you can check the constraint created using 'sp_help myTable'. — hallie
– hallie, Commented Jun 5, 2013 at 3:43
Can you give an example of inserts that should be rejected but aren't? Your current table definition allows NULLs, and NULL treatment by constraints can surprise some people, if that's a factor. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Jun 5, 2013 at 6:04

Noel · Accepted Answer · 2013-06-05 05:53:57Z

1

You have to give a name to the constraint.

CREATE TABLE myTable
(
   begin   NUMBER (10),
   end     NUMBER (10),
   CONSTRAINT constr_begin_end CHECK (begin < end)
);

Also, begin and end are keywords in Oracle. Avoid this in column names, variable names.

answered Jun 5, 2013 at 5:53

Noel

10.6k30 gold badges53 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1