Shimmy Shimmy - 4 months ago 35
SQL Question

SQL constraint minvalue / maxvalue?

Is there a way to set a SQL constraint for a numeric field that min value should be 1234 and max value should be 4523?

Answer

SQL Server syntax for the check constraint:

create table numbers (
    number int not null
        check(number >= 1234 and number <= 4523),
    ...
)

create table numbers (
    number int not null,
    check(number >= 1234 and number <= 4523),
    ...
)

create table numbers (
    number int not null,
    constraint number_range_check
        check(number >= 1234 and number <= 4523),
    ...
)