Re: Re: ALTER TABLE ADD CONSTRAINT

> >> Also, I see that alter table add constraint does not work for defaults.
> >>
> >> Is this something that is going to be added?
> >
> > That I do hope will be added since the only way to replicate the
> > functionality is to drop, readd and repopulate a table.
> >
> > Greg
>
> I am not sure specifically what you are looking for but you can add a
> default value to a column in an ALTER TABLE statement:
>
> ALTER TABLE two ALTER COLUMN col_b SET DEFAULT 1;

Sorry, I was assuming the original author was correct in his statement. I
thought there was some limitation here though... maybe it was dropping the
default that I was thinking of.

> The biggest thing that I have noticed is many things require you to use
> separate ALTER statements in order for them to work.

That's what I was pointing out :)

Greg