Teste case:

create database 't.fdb';

create table t1 (n integer);
create table t2 (n integer);

create domain d1 integer check (value = (select n from t1));
commit;

set autoddl off;

alter domain d1 drop constraint;
alter domain d1 add constraint check (value = (select n from t2));;
commit;

drop table t1; -- cannot drop - there are dependencies
commit;