Re: Add Constraint

Posted in 2005

Colin Dawson — Wed, 31 Aug 2005 11:07:03 +0000 — source: Usenet: comp.databases.informix

Sorry..... It's a Foreign Key constraint Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Obnoxio The Clown" <obnoxio@serendipita.com> >To: "Colin Dawson" <cjd_1955@hotmail.com> >CC: informix-list@iiug.org >Subject: Re: Add Constraint >Date: Wed, 31 Aug 2005 11:03:08 +0100 (BST) > > >Colin Dawson said: > > > > I've just added a constraint on a table both the master and detail >tables > > have over 100M rows, and it took almost 2 hours, does anyone know what > > exactly happens during an ADD CONSTRAINT. > >What kind of constraint? > >-- > >Bye now, >Obnoxio > >"C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" > - Coluche > >A smile is a gift that is free to the giver and precious to the recipient. >But giving someone the finger is free too, and I find it more personal and >sincere. sending to informix-list