Viewing Constraint status (Disabled/Enabled)?

• Jeff-67583

  SSCertifiable

  Points: 5625

  More actions

  October 12, 2004 at 2:44 pm

  #84468

  Hi,

  Is there a way to find out if a constraint status is disabled or enabled? Is there a system table that shows this?

  Many thanks. Jeff

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  October 12, 2004 at 9:48 pm

  #526448

  Yes, this can be done. Check out OBJECTPROPERTY in BOL, specifically the CnstIsDisabled property name.

  Phil

  ---