On Wed, 06 Aug 2003 12:48:19 -0400, hobbes wrote:
<SNIP>

> but just another question :
> does the index (not unique , not PK)
> are referenced in sysconstraints ?
> Do we have to see the name of the index in sysconstrainsts ? (in idxname
> , or constrname)
> just for information, since i do not need this

All constraints which require an index (ie PK, FK, UNIQUE) will have the
index entered in the syscontraints, yes. Some constraints (Check, NOT
NULL) do not require an index and so the field is NULL.

Art S. Kagel