Re: Dropping Informix Created Indexes

In article <6q736c$7d9$1@nnrp1.dejanews.com>, lcardwel@dencom.army.mil wrote: > I have an index thats name was generated via informix. I need to drop and > recreate the index but cannot due to the special character informix places in > front of the name. > > Does anyone know a workaround to dropping this index other than dropping the > entire table? > > TIA, Lori > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum > Informix will create an index when applying a constraint like a primary key. Determine what constraint/index you want to drop and by removing the constraint with the ALTER TABLE DROP CONSTRAINT command then constraint/index will be removed. Frank Testa -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum