On Sat, 2002-11-30 at 15:06, bpalmer wrote:
> > * Compliant ADD COLUMN
>
> I've missed the thread (if there was one), how is it non-compliant?
ALTER TABLE .. ADD COLUMN colname integer DEFAULT 42 NOT NULL
CHECK(colname <= 42) REFERENCES tab2 ON DELETE CASCADE;
Can't do the above in a single statement. It takes five statements.
It's something I'd like to see added as well.
--
Rod Taylor <rbt@rbt.ca>