Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
FK constraint not checked |
Tue, Feb 27 2007 10:52 AM | Permanent Link |
"Ole Willy Tuv" | 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 |
Wed, Feb 28 2007 9:16 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |