Thread

1. ehm... drop column...

   andrea gelmini <bungle@linux.it> — 2000-10-31T07:46:54Z

   hi all,
   	i'm going mad trying to find a way to delete a column
   	in a table.
   	if i try it like in oracle, with alter, it doesn't
   	work, and i didn't find anything in the docs...
   	so, i'm afraid it's not possibile...
   
   thanks for your time,
   andrea
   
   

2. Re: ehm... drop column...

   D. Duccini <duccini@backpack.com> — 2000-10-31T07:54:12Z

   its not really possible
   
   best bet is to
   
   1. rename the column to something
   
      oldcolumn
   
   optionally
   
   2. create a new table, and select into this new "clean" table, and the
   drop the old one
   
   
   On Tue, 31 Oct 2000, andrea gelmini wrote:
   
   > hi all,
   > 	i'm going mad trying to find a way to delete a column
   > 	in a table.
   > 	if i try it like in oracle, with alter, it doesn't
   > 	work, and i didn't find anything in the docs...
   > 	so, i'm afraid it's not possibile...
   > 
   > thanks for your time,
   > andrea
   > 
   
   
   -----------------------------------------------------------------------------
   david@backpack.com            BackPack Software, Inc.        www.backpack.com
   +1 651.645.7550 voice       "Life is an Adventure.    
   +1 651.645.9798 fax            Don't forget your BackPack!"   
   -----------------------------------------------------------------------------
   
   
   

3. Re: ehm... drop column...

   Poul L. Christiansen <poulc@cs.auc.dk> — 2000-10-31T13:34:52Z

   3. Wait to january (hopefully not longer) when version 7.1 will have the
   new "DROP COLUMN" command.
   
   "D. Duccini" wrote:
   > 
   > its not really possible
   > 
   > best bet is to
   > 
   > 1. rename the column to something
   > 
   >    oldcolumn
   > 
   > optionally
   > 
   > 2. create a new table, and select into this new "clean" table, and the
   > drop the old one
   > 
   > On Tue, 31 Oct 2000, andrea gelmini wrote:
   > 
   > > hi all,
   > >       i'm going mad trying to find a way to delete a column
   > >       in a table.
   > >       if i try it like in oracle, with alter, it doesn't
   > >       work, and i didn't find anything in the docs...
   > >       so, i'm afraid it's not possibile...
   > >
   > > thanks for your time,
   > > andrea
   > >
   > 
   > -----------------------------------------------------------------------------
   > david@backpack.com            BackPack Software, Inc.        www.backpack.com
   > +1 651.645.7550 voice       "Life is an Adventure.
   > +1 651.645.9798 fax            Don't forget your BackPack!"
   > -----------------------------------------------------------------------------