Re: Rename Indexes

Posted in 1997

Art S. Kagel — Tue, 16 Dec 1997 17:42:51 -0500 — source: Informix-list mailing list archive (1991-1998)

David J Meyer wrote: > > > > I know that Informix does not have a 'Rename Index' nor > 'Rename Constraint', but does Informix provide a stored > procedure to 'Rename Index' information in the systables, > sysindexes or sysconstraints... Will damage be caused in > doing this if I do it myself(YES)? > > I am running 7.13 and am using DBIPERL under AIX. I am > looking at saving the time of being able to rename a > table and not having to drop and create the indexes/constraints. Don't try it. It will not work and you may trash things to such an extent that you will have to call tech support to clean up and they may not be able to. Never mess with the system tables in 7.xx. There are very few fields which are not echoed elsewhere, disagreements are trouble. Art S. Kagel