What are the challenges you face when working across database platforms? Take the survey
Options

Ignore constraint names

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited January 29, 2004 10:46AM in SQL Compare Previous Versions
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!!
>
>
This discussion has been closed.