Can a Check constraint relate to another table?

In response to your comment on GSerg’s answer, here’s an example check constraint using a function:

alter table YourTable
add constraint chk_CheckFunction
check (dbo.CheckFunction() = 1)

Where you can define the function like:

create function dbo.CheckFunction()
returns int
as begin
    return (select 1)

The function is allowed to reference other tables.

Leave a Comment