Re: dropping table column
From: Ray Chance <rchance_at_netcom.com>
Date: Sat, 2 Oct 1993 19:09:04 GMT
Message-ID: <rchanceCEAAJ4.7n1_at_netcom.com>
Date: Sat, 2 Oct 1993 19:09:04 GMT
Message-ID: <rchanceCEAAJ4.7n1_at_netcom.com>
Serge Taylor (st0u+_at_andrew.cmu.edu) wrote:
: Am I correct in inferring that one cannot (at least in v.6)
: drop a column from a table?!*%
Yes - at least not directly as in "alter table drop column...". Same for ORACLE7. It can be done via a couple routes one of which is backup old table, create new table without the column to be dropped, drop old table, rename new table to old table name.
: Serge Taylor
Received on Sat Oct 02 1993 - 20:09:04 CET