Drop Recreate table or alter table drop column. Which is

Hi Gurus, If the table is empty U need to drop one of the columns, do you 1) alter table tab_name drop column col_name or 2) drop recreate table I use option (1). Which is a better choice ? TIA Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Drop Recreate table or alter table drop column. Which

). -Original Message- From: CHAN Chor Ling Catherine (CSC) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Subject: Drop Recreate table or alter table drop column. Which is Hi Gurus, If the table is empty U need to drop one

RE: Drop Recreate table or alter table drop column. Which is

, August 29, 2001 10:21 AM To: Multiple recipients of list ORACLE-L Subject:Drop Recreate table or alter table drop column. Which is Hi Gurus, If the table is empty U need to drop one of the columns, do you 1) alter table tab_name drop column col_name or 2) drop recreate table I use

RE: Drop Recreate table or alter table drop column. Which

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 only way to go. That is of course unless you want

Re: Drop Recreate table or alter table drop column. Which

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 with the synonyms.