Post reply

Check if Constraint is enabled or disable

  • November 3, 2011 at 1:03 am

    #250236

    Comments posted to this topic are about the item Check if Constraint is enabled or disable

  • November 3, 2011 at 1:21 am

    #1402507

    I think script is missing. Can you please check?

    Thanks

  • November 3, 2011 at 1:53 am

    #1402513

    excuse me but this is my first post. I edited the script and now I wait for the publication of this issue.

    This is the script :

    select

    [Table] = o2.name,

    [Constraint] = o.name,

    [Enabled] = case when ((C.Status & 0x4000)) = 0 then 1 else 0 end

    from sys.sysconstraints C

    inner join sys.sysobjects o on o.id = c.constid -- and o.xtype='F'

    inner join sys.sysobjects o2 on o2.id = o.parent_obj

  • November 3, 2011 at 3:35 am

    #1402543

    roberto armellin (11/3/2011)

    excuse me but this is my first post. I edited the script and now I wait for the publication of this issue.

    This is the script :

    select

    [Table] = o2.name,

    [Constraint] = o.name,

    [Enabled] = case when ((C.Status & 0x4000)) = 0 then 1 else 0 end

    from sys.sysconstraints C

    inner join sys.sysobjects o on o.id = c.constid -- and o.xtype='F'

    inner join sys.sysobjects o2 on o2.id = o.parent_obj

    No issues. Thanks for sharing.

    Thanks

  • May 12, 2016 at 6:31 am

    #1878512

    Thanks for the script.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply