Re: InformixIDS9.4 ODBC driver query

> > When a constraint is created on a table, Informix will create an > underlying index whose first character is a space. The constraint > name will be prefaced with a 'u'. Not what I wanted to hear but thanks anyway! Is this documented anywhere? Alex

On 19 Aug 2003 01:07:56 -0700, azp74@hotmail.com (Alex) wrote: >> >> When a constraint is created on a table, Informix will create an >> underlying index whose first character is a space. The constraint >> name will be prefaced with a 'u'. > >Not what I wanted to hear but thanks anyway! >Is this documented anywhere? Sory, I missed original message, but I think that better for you will be to: 1. create table without constraints 2. create indexes for your primary, unique and / or foreign key constraints 3. alter table to create constraints. If you that you can give names to your indexes and constraints as you want Nebojsa ------------------------------------ Remove spam block (DELETE_) to reply