Re: Identifying Disabled Constraints

At 11:10 AM 11/3/97 -0500, you wrote: }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 }-- }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!) } } check out sysobjstate. The schema and FKs are documented in the usual place (Sql Ref Chap 2) cheers j.