copy tables and constraints

Hello everyone,

I want drop one or two columns in a table. Using the SQL Language I copy the important
columns in an new table :

create table tmp_table ( nr, name, ... ) as select nr, name, ... from org_table;

But what about the constraints ? How can I copy the constraints into the new table ?

thanks in advance

Rainer

-- Received on Tue Nov 17 1998 - 17:04:18 CST