Re: CREATE TABLE AS ...

On Tue, Jul 23, 2002 at 15:48:07 +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?

Another option is to use create table and insert select. The create can
then set up the table exactly like you need. And then you can copy over
data using insert selecting from the source table.