How can we help you today? How can we help you today?

Drop column with unnamed constraint

Hi,
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.
Bruno
0

Comments

1 comment

Sort by
  • Eddie D
    Hi, thank you for your forum post.

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

    - Ignore System Constraint Names
    and
    -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
    Eddie D
    0

Add comment

Please sign in to leave a comment.