Drop column with unnamed constraint
bparentpichette
Posts: 1 New member
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.
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.
Tagged:
Best Answer
-
Eddie D
Posts: 1,803 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
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
