> This will give you the index name. Remember that if the unique index
> doesn't exist when you generate the primary key constraint, Informix
> will create one for you, as a combination of tabid and constrid. When
> Informix does this for you, the first character if idxname will be
> blank.

Yes that what i'm trying to get ...
in fact i want to obtain 3 things :
1)the index name,
2)the uniquess of the index
3)if the index is a primary key or not

> >When i try to make the link between => sysconstrints and sysindexes on
> >idxname it does not work.
> >
> >The explanation:
> >=============
> >in fact idxname in sysconstraints is not always filled with the index
name.
> >sometimes it is fill with a value and sometimes not.(just blank)
> >
>
> On my version, when idxname isn't set, it is because constrtype is
> 'N', a not null constraint on a column. What is your Informix
> version?

I use IDS 9.3 (i wait for the 9.4 ..... IBM seems on hollyday ...)
Something frightened me in your answer => 99% of our database is made with
not null constraint on columns.......
(i gonna try to find information about that)


Ok, thk you for the answer....

=======
=======

AND FINALLY .....
after checking my database creation script ....
i noticed one big (big, really ..... i can say huge) BUG.
My script is auto-generated from an Oracle database .....
and the generation of the primary key script is done randomly due to a
"poor" parameter...


so this time too , it's my fault.
I'm sorry....
thk you for the answer, it put me on the right way to find the issue.


Bye
Arnaud

Hope that the not null constraints isn't a limitation !