Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    12

    Unanswered: Dropping a column from table

    Hello,

    I am trying to drop a column (column does not have any data, not a key) using the following command.

    alter table plant drop column plant_supplier;

    Oracle throws the following error ORA-00905: Missing Keyword.

    Could any one please advise what is happening?

    Thanks,
    Dessri

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Dropping a column from table

    What Oracle version? Probably one that doesn't support dropping columns. The syntax is fine:

    SQL> alter table t drop column c;

    Table altered.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •