Re: Naming Indexes on IDS 7.31 ...

From: Arnaud ANDRIEUX <arnaud.andrieux@aql.fr> > >I have to solve a 'great' problem with Informix Dynamic Server 7.31 TC2 >on NT4 SP5 concerning system indexes naming : we design a database for a >client who wants to apply explicits naming convention on indexes. Off >course we do so on specific indexes we create on particular columns. But >I did not found in Informix SQL documentation the mean to specify names >of system indexes (indexes on primary or foreign keys) when creating >these constraints... > >I tried to create all indexes but the script failed when it was run >because system indexes where still existing ! Informix seems always to >generate system indexes !! Could you tell me if it is possible to change >this behaviour ? Or have you any solution to rename system indexes >(please dont' tell me to drop and create all of these indexes...) > >Thanks a lot for your answers. Even if I tell you to drop and create all of these indexes...? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com