Re: CREATE TABLE AS ...

--On mardi 23 juillet 2002 15:48 +0200 Raphael Bauduin
<raphael(at)be(dot)easynet(dot)net> wrote:

> Hi,
>
> In a data model change, I wanted to use the "create table as select"
> feature. However, I want that table to have a primary key defined, and
> thus a field defined as NOT NULL. I didn't find a way to add a NOT NULL
> constraint on a column of an existing table. If there isn't, what's the
> best way to go? A COPY?

why not just :
create table new_table (new fields with all you need);
insert into new_table <the same select as you had in your create as>;

--
Mathieu Arnold