Ignore constraint names
Brian Donahue
Posts: 6,590 Bronze 1
Hi Thomas,
I've never heard of a bug in the software that would cause the ignore
constraint names function to not work. Is this the only difference between
the two tables, or are there other differences there.
Also, keep in mind that this option has no effect on the Show SQL
Windows: just the comparison's main result...
Regards,
Brian Donahue
Red Gate Technical Support
"Thomas Zeng" <zzy@nonospam.com> wrote in message
news:TqW51Wd4DHA.1904@server53...
> ALTER TABLE [dbo].[BROKER] ADD CONSTRAINT [DF__BROKER__External__530E3526]
> DEFAULT (0) FOR [ExternalBal]
>
> ALTER TABLE [dbo].[BROKER] ADD CONSTRAINT [DF__BROKER__External__2043898E]
> DEFAULT (0) FOR [ExternalBal]
>
>
>
> Hello,
>
> The two lines above are listed as being different even though I selected
the
> option View -> Option -> Object -> Ignore Names of Constraints, Triggers
> etc... Is that the right behavior? I don't really care about the name of
a
> constraint being different.
>
> Thanks!!
>
>
I've never heard of a bug in the software that would cause the ignore
constraint names function to not work. Is this the only difference between
the two tables, or are there other differences there.
Also, keep in mind that this option has no effect on the Show SQL
Windows: just the comparison's main result...
Regards,
Brian Donahue
Red Gate Technical Support
"Thomas Zeng" <zzy@nonospam.com> wrote in message
news:TqW51Wd4DHA.1904@server53...
> ALTER TABLE [dbo].[BROKER] ADD CONSTRAINT [DF__BROKER__External__530E3526]
> DEFAULT (0) FOR [ExternalBal]
>
> ALTER TABLE [dbo].[BROKER] ADD CONSTRAINT [DF__BROKER__External__2043898E]
> DEFAULT (0) FOR [ExternalBal]
>
>
>
> Hello,
>
> The two lines above are listed as being different even though I selected
the
> option View -> Option -> Object -> Ignore Names of Constraints, Triggers
> etc... Is that the right behavior? I don't really care about the name of
a
> constraint being different.
>
> Thanks!!
>
>
This discussion has been closed.
