create table t1
(
 pkey integer not null,
 constraint pk_t1 primary key (pkey)
)

create table t2
(
 pkey integer not null,
 fkey integer,
 constraint pk_t2 primary key (pkey)
)

insert into t1 values (1)

insert into t2 values (100,100)

alter table t2
add constraint fk_t2 foreign key (fkey) references t1 (pkey)

The ALTER TABLE statement executes without a complaint, but should throw a
constraint violation error since the table data does not satisfy the
constraint.

Ole Willy Tuv

Ole,

<< The ALTER TABLE statement executes without a complaint, but should throw
a constraint violation error since the table data does not satisfy the
constraint. >>

Same situation as your other post.

--
Tim Young
Elevate Software
www.elevatesoft.com