I lost my constraints, but the indexes still there, what's
Posted in 1996
Topics: Triggers, Constraints & Referential Integrity
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. | +----------------------------------------------------------------------+