Alter Default Value don't work
i use the SQL Compare GUI in Version 18.104.22.16821.
So we change default values in some columns on multiple Tables.
Old value = ' ' (one blank)
New value = '' (empty string)
The program creates the following statement
ALTER TABLE [dbo].[Tablename] ADD CONSTRAINT [DF__Tablename__Nam__290129A8] DEFAULT ('') FOR [Columnname]
If i run the script the following error was greated:
Msg 1781, Level 16, State 1, Line 3
A DEFAULT value is already bound to the column.
Msg 1750, Level 16, State 0, Line 3
The restriction or index could not be created. See previous errors.
What can i do to compare the databases?
0 · Share on Twitter