Re: newbie question: how to delete a column from a table definition

In article <35328A83.5C909F6D_at_access-laserpress.com>, Kevin P. Fleming <kfleming_at_access-laserpress.com> writes
>Except for SQL Server, which doesn't allow column modification of any
>kind without dropping the table.
>

  And Ingres which has the same problem..

  SQL Server was Sybase 4.9 wasn't it?

  Hurrah for Informix! The only big one to support alter table from the   start!  

>Jonathan Gennick wrote:
>>
>> On 10 Apr 1998 07:44:40 GMT, "Steven Cools"
>> <Steven_at_digimap.be> wrote:
>>
>> > this is a very simple question : how can I delete a column from a table
>> >definition using PL/SQL? I searched through the manual of PL/SQL but I
>> >couldn't find it. Why is it not as simple as in Informix/SQL:
>> >
>> >alter table TABLENAME
>> >drop NAME-OF-COLUMN
>>
>> I think Oracle is the only database on the face of the earth
>> that can't handle this<g>. There is no "DROP COLUMN"
>> command. You have to save the data, drop the table, recreate
>> the table, reload the data, and recreate all constraints &
>> indexes in order to remove the column.
>>
>> regards,
>>
>> Jonathan

--
David Williams

Maintainer of the Informix FAQ
 Primary site (Beta Version) http://www.smooth1.demon.co.uk

 Official site                http://www.iiug.org/techinfo/faq/faq_top.html

I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care Received on Wed Apr 15 1998 - 16:04:32 CDT