Post reply

hi

  • September 21, 2006 at 12:04 pm

    #61827

    hi everybody can u pls explain how to drop a constraint in sql server and how to describe  a constraint using sp_help

  • September 21, 2006 at 12:16 pm

    #661833

    Drop constraint:

    ALTER TABLE table DROP CONSTRAINT constraintname

    Describe constraint:

    sp_helptext [ @objname = ] 'constraintname'

  • September 21, 2006 at 2:33 pm

    #661860

    an example

    ALTER TABLE dbo.Table1

     DROP CONSTRAINT CK_Table1

Viewing 3 posts - 1 through 2 (of 2 total)

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