Re: Drop column help

Jane Mikityanskaya (jane_at_hnrc.tufts.edu) wrote:
: I'm using Oracle 7.3 WGS on NT 4.0.
: Is it possible to drop a column from a table ? SQL does not have this
: clause through ALTER TABLE command. However, in the Enterprise Manager
: there is a button that "allow to remove a column from a list" (according
: to the on-line help). That either did not work for me, the button gets
: unable all the time.

You cannot drop a column from a table once that table has been created, you need to create a new table with all the other columns and copy the data into it.

The "remove column from list" button is probably just for removing it from a table definition you're putting together but have not yet actually created, similar to removing a line with a column definition from a text script to create a table. (My personal opinion is that tables should be created through scripts anyway, not through graphical tools like EM; you get to keep the script around afterwards, which makes for good documentation and also makes it easier to create the same or similar tables later.)

-- 
========================================================================
"Villains, I say to you now:       |   Mike Carmack
 KNOCK OFF ALL THAT EVIL!"         |   Vulcan Dragon -==(UDIC)==-
    S P O O N !!!!    - The Tick   |   mcarmack_at_freenet.columbus.oh.us