RE: Checking columname for index

Actually, you can link syscolumns.colno to sysindexes.part1,2,3,etc. The logic is messy, though, you might consider doing 'info indexes for table . . .' and then some text processing in Perl or awk to get your answer. > -----Original Message----- > From: albertrocker@my-deja.com [SMTP:albertrocker@my-deja.com] > Sent: Monday, March 27, 2000 9:12 AM > To: informix-list@iiug.org > Subject: Checking columname for index > > Hello, > > I am maintaining some SPL, which contains a CREATE INDEX statement. > > I am taking this opportunity to make the procedure a little more > robust, by checking that the column in question is not already indexed > before issuing the 'CREATE' > > The system catalogue does not seem to provide much help, as I can't > link sysindexes with syscolumns. > > Does anyone have any SQL or ideas that may be able to help me in this? > > Thanks. > > > Sent via Deja.com http://www.deja.com/ > Before you buy.