Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Interbase/Oracle Drop Column

0 views
Skip to first unread message

Pavel Odstrčil

unread,
Oct 21, 1997, 3:00:00 AM10/21/97
to

Carol Ferguson wrote:

> I am modifying an existing Delphi/Interbase project to on Oracle also.
>
> Interbase allowed me to use the ALTER TABLE <tablename> DROP <column>
> to
> drop a column from a table. Oracle doesn't like this command. Is there
> a
> way to drop a column in Oracle?
>
> Gary Groshner
> gar...@eastsoft.com

No, temporary table must be used.

Pavel


Aleksei A. Alekseenko

unread,
Oct 21, 1997, 3:00:00 AM10/21/97
to

Carol Ferguson <car...@eastsoft.com> wrote in article
<344B78...@eastsoft.com>...

> I am modifying an existing Delphi/Interbase project to on Oracle also.
> Interbase allowed me to use the ALTER TABLE <tablename> DROP <column> to
> drop a column from a table. Oracle doesn't like this command. Is there a
> way to drop a column in Oracle?

Oracle7 has no commands to drop a column. There you have to recreate the
table.

--
Aleksei A. Alekseenko, <http://www.ptrsrv.spb.ru/alex>
==================== http://www.ptrsrv.spb.ru ===============
Peter-Service Ltd.
190121 Russia, St.Petersburg, 35 Dekabristov str., p/b 149
al...@ptrsrv.spb.ru tel. +7-812-3258369 fax +7-812-3258353
=====================================================


0 new messages