Subject | Re: Add NOT NULL constraint within transaction |
---|---|
Author | davidlhoffman66 |
Post date | 2007-01-30T19:37:39Z |
> You don't need a temporary column; just issue these two DDL statementsThanks, Paul, I appreciate the help.
> and commit. Supposing the current column type is int:
>
> create domain intnn as int not null;
> alter table MyTable alter MyColumn type intnn;
Best-
-David