Re: I lost my constraints, but the indexes still there, what's

m.mejia@server1.codetel.net.do ("Ing. Melvin Perez Cedano") wrote: >Hello InformiXperts! >Several times I've lose constraints (generally foreign keys) without any >satisfactory reason. So I've re-created them :(, but in this case I couldn't >re-create them because the indexes, automatically created when these >constraints were defined, still defined in the database. As you know, these >indexes cannot be dropped using "drop index". >I would like to re-define these constraints without drop my table, because >there are a lot of references pointing to it. Could be a lot of work around >this. >Anybody has had been involved in this? >Please, help me! >Thanks! > ////// >+---------------------------ooo-O-O-ooo--------------------------------+ >| U | >| Melvin Perez Cedano Santo Domingo, Dom. Rep.| >| Vice-President m.mejia@codetel.net.do | >| Systems Development Phone (809) 686-5574 | >| CAM Informatica, S. A. Fax (809) 686-5467 | >+----------------------------------------------------------------------+ >| ALL RIGHTS RESERVED | >| This posting is copyright and may be used only for the purposes | >| of professional study or the professional exchange of information. | >| Use of this posting by any commercial organisation for the | >| purposes of vilifying another is explicitly prohibited. | >+----------------------------------------------------------------------+ We found that it makes good sense to create the index and name it before you add the constraint. If the index is already there informix will not dynamically create one. This makes monitoring these indexes easier too. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com