CREATE TABLE AS ...
CREATE TABLE AS ...
От:
Raphael Bauduin <raphael.bauduin@be.easynet.net>
Дата:
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? Thanks. Raph