Marc Munro <[EMAIL PROTECTED]> writes:
> I am puzzled by the cascade and restrict options to the alter domain
> drop constraint command.
They don't do anything.
I think they were put in because we have this meme that the SQL spec
requires RESTRICT/CASCADE options on every type of DROP, but so far
I am puzzled by the cascade and restrict options to the alter domain
drop constraint command.
I do not see how a dropping a check constraint should cascade to
anything, or indeed be restricted by anything.
My reasoning is simple: if I drop a check constraint on a domain, no
data should be affecte