Re: copy tables and constraints

From: K. Raghuraman <kraghu_at_india.hp.com>
Date: Thu, 19 Nov 1998 10:57:51 +0800
Message-ID: <3653892F.C3762F16@india.hp.com>

I think you will not get the constraints; you will have to manually recreate them.

Raghu

R. Neideck wrote:
>
> 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 Wed Nov 18 1998 - 20:57:51 CST