Which system table lists the constrain names in a database?

The Subject says its all. For example, a constrain name r602_301, is there a system table list all these constrain names? Thank you! -- Why we want to teach our babies to talk and walk, then later we tell them "sit down!", "be quiet!" ? Democracy is not a better way for a solution, it is just another way to spread the blames. --Raymond

I'm not entireley sure, but I think that the table is 'informix'.sysconstraints the latest myschema uses this table to retrieve its contstraint names. -Dan Raymond Chui wrote: > > The Subject says its all. > > For example, a constrain name r602_301, is there a system table list > all these constrain names? > Thank you! > > -- > Why we want to teach our babies to talk and walk, > then later we tell them "sit down!", "be quiet!" ? > > Democracy is not a better way for a solution, > it is just another way to spread the blames. > > --Raymond

<HUMOR ON> After surveying the previous responses, and without prejudice to independent knowledge, I have determined that the recommended response is: sysconstraints <HUMOR OFF> You'll have to excuse me today I'm in a weird mood. ;-) Art S. Kagel Raymond Chui wrote: > > The Subject says its all. > > For example, a constrain name r602_301, is there a system table list > all these constrain names? > Thank you! > > -- > Why we want to teach our babies to talk and walk, > then later we tell them "sit down!", "be quiet!" ? > > Democracy is not a better way for a solution, > it is just another way to spread the blames. > > --Raymond