ENABLED/DISABLED CONSTRAINTS ?

Posted in 2000

Stefan Moens — Wed, 17 May 2000 15:43:49 GMT — source: Informix-list mailing list archive (1991-1998)

↪ replying to Stefan Moens

Carlson@WHSmith — Wed, 17 May 2000 15:10:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Stefan Moens wrote: > > Hi, > > How can I find out if a constraint is ENABLED / DISABLED ? > > Thx, > Stefan > Through SQL could be: database (dbname); select tabname, constrname, obj.state from sysobjstate obj, sysconstraints con, systables tab where tab.tabid = con.tabid and con.tabid = obj.tabid I believe that dbschema also displays the status of an object with constraints disabled. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

↪ replying to Stefan Moens

Art S. Kagel — Mon, 22 May 2000 18:06:59 -0400 — source: Informix-list mailing list archive (1991-1998)

Stefan Moens wrote: > > Hi, > > How can I find out if a constraint is ENABLED / DISABLED ? Look in sysobjstate via the name of the constraint/index in the name column. The state column will contain 'E' if enabled. Art S. Kagel