Results 1 to 4 of 4

Thread: delete a column

  1. #1
    Join Date
    Jun 2004
    Posts
    42

    Unanswered: delete a column

    Hi
    after creating a table can i delete one of the columns

    thanks

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

    alter table t drop column c;

  3. #3
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    On high volume systems you might not want the system taxed by dropping a column. Look at the Alter Table command for syntax to mark one or more columns as "unused". When the system is at a low point, there is Alter Table syntax to drop unused columns.

    This method is not necessary in low volume systems, like development databases. Also, note unused <> recycle bin. Once marked unused you cannot undo the operation.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by markrem
    On high volume systems you might not want the system taxed by dropping a column. Look at the Alter Table command for syntax to mark one or more columns as "unused". When the system is at a low point, there is Alter Table syntax to drop unused columns.
    I agree with Mark. If you have a table with large amounts of data it is
    much easier/efficient to mark the column as unused and then delete.
    Unused will go into effect right away while dropping the column on a
    large table could take a great deal of time.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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