RE: Identifying Disabled Constraints

Posted in 1997

Sujit Pal — 5 Nov 1997 02:53:32 -0500 — source: Informix-list mailing list archive (1991-1998)

David Try the system catalog table sysobjstate. The objtype column value for = constraints is "C" and the state column can be "E" (enabled) or "D" = (disabled). HTH Sujit Pal ---------- From: David Snyder[SMTP:snyded@towers.com] Sent: Monday, November 03, 1997 9:10 AM To: informix-list@rmy.emory.edu Subject: Identifying Disabled Constraints Where in the system catalogs can I check if a constraint has been disabled. The obvious "sysconstraints" table was no help (unless I missed something). Thanks! DAS --=20 David Snyder @ Towers Perrin - Philadelphia, PA EMAIL: (w) snyded@towers.com (h) dave@snide.com WEB: http://www.ece.vill.edu/~dave/ (Now enhanced w/Frames!)