Post reply

alter constraint

  • December 6, 2006 at 9:11 am

    #193428

    Can I alter an existing check contraint or do I have to drop it and recreate it?

    thanks!

  • December 6, 2006 at 5:26 pm

    #676478

    You can alter an existing check constraint or change the constraint expression but only thru the Enterprise Manager.

    Ronald San Juan | SQL DBA
    ID 710124 ~ Code "Northwind"

  • December 7, 2006 at 8:14 am

    #676624

    Ronald is right, in Enterprise Manager, it appears that you can edit an existing, but if you profile the database, you will see it is really dropping the constraint, and then creating a new one with the same name.

    technically, that is what you need to do..drop existing and then add the new one.

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 7, 2006 at 9:04 am

    #676653

    thanks, guys!

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

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