SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create function dbo.foo(@v varchar(10))
returns int
as
begin
    return len(@v)
end
select dbo.foo('aaa')


(No column name)


3


create table bar (
   a varchar(10) check (a < 5)
);
create table baz (
   a varchar(10) check (dbo.foo(a) < 5)
);
alter function dbo.foo(@v varchar(10))
returns int
as
begin
    return len(@v)
end
Msg 3729 Level 16 State 3 Line 1
Cannot ALTER 'dbo.foo' because it is being referenced by object 'CK__baz__a__267ABA7A'.