> Jacques Kilchoer wrote:
>
> > -Original Message-
> > From: William Rogge [mailto:[EMAIL PROTECTED]]
> >
> > Because of any synonyms (which are based off of object
> > numbers), Option 1
> > is the only way to go. That is of course unless you want to
> > perform extra
> > work dealing w
Title: RE: "Drop & Recreate table" or "alter table drop column". Which is
> -Original Message-
> From: William Rogge [mailto:[EMAIL PROTECTED]]
>
> Because of any synonyms (which are based off of object
> numbers), Option 1
> is the onl
Because of any synonyms (which are based off of object numbers), Option 1
is the only way to go. That is of course unless you want to perform extra
work dealing with the synonyms.
-Original Message-
From: CHAN Chor Ling Catherine (CSC) [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, Augu
In an 8i database, dropping a column is certainly preferred over a
rebuild, because if you drop & re-create the table, you have to re-create
all grants, indexes, triggers and constraints. Since the table is empty (you
said so) you will not fragment any data (row chaining and alike).
> -Origin