Drop column with unnamed constraint

I wanted to drop a column on which there is an unnamed constraint.

The problem is when we generate the deployment script (using SQL Compare), the script fails because the targeted database has a different constraint name (System Generated Constraint Name).

Is there a way to drop a column and any constraint on that column.

Best Answer

  • Eddie DEddie D Posts: 1,768 Rose Gold 5
    Hi, thank you for your forum post.

    The are 2 SQL Compare options that should help you do this:

    - Ignore System Constraint Names
    -Ignore Constraint and Index Names

    Edit project or when creating a new SQL Compare project, select the options tab and enable the two options above.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.