Re: ENABLE/DISABLE CONSTRAINT NAME

于 2013-09-03 08:15, David Johnston 回复:
> Jeff Davis-8 wrote
>> Is there any semantic difference between marking a constraint as
>> DISABLED and simply dropping it? Or does it just make it easier to
>> re-add it later?
>
David Johnston wrote:
> I cannot answer the question but if there is none then the main
> concern I'd
> have is capturing "meta-information" about WHY such a constraint has
> been
> disabled instead of dropped.

Drop/build and disable/enable constraint has no fundamental difference,
and could achieve the same purpose.What I do also more convenient for
the user.
Recording the disabled constraints is easier than recoding all the
constrains.
What's more, a lot of people ever asked about turing off constraint and
The sql2008 support this.So I think it's necessary in some ways.

> I guess this whole feature extends from the trigger disable feature
> that
> already exists. Given we have the one adding this seems
> symmetrical...
>
> I cannot really see using either feature on a production system (if
> following best practices) but I can imagine where they could both be
> helpful
> during development. Note with this usage pattern the
> meta-information about
> "why" becomes considerably less important.
>
> David J.

Wang Shuo
HighGo Software Co.,Ltd.
September 3, 2013