kal121_at_yahoo.com wrote:
>
> Oracle 8i allows column drops (but not previous versions):
I know that.
>
> ALTER TABLE my_table DROP COLUMN col1;
> Make sure you have your COMPATIBLE parameter set to 8.1.0.
>
> If you are not running 8i, you can simply recreate the table without
> the column, if you can afford the downtime.
What about all the constraints and the foreign keys from and to a
table?
>
> In article <385A558D.F6C3E0BB_at_intrasoft.gr>,
> CC <kkons_at_intrasoft.gr> wrote:
> > hi all,
> >
> > Does anyone know where can I find a package or a tool that can drop a
> > column of a table?
> > I already got one but it seems not to work.
> > I 've heard about Hora-4 tool but I can't download it and it is only a
> > trial version.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 17 1999 - 16:26:04 CST
