DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006

    How to set an UNUSED col as USED again

    The ALTER TABLE tablename SET UNUSED COLUMN colname CASCADE CONSTRAINTS statement is apparently used for marking a column as UNUSED..
    I tried loking up a few books including Chip Dawes ..However none of the book mention how to Unmark a UNUSED Column.(so that the column becomes visible again while viewing the table definition !!)

    Would appreciate if someone could give me the syntax for setting an UNUSED column as USED again
    Thanks- Sunnny

  2. #2
    Join Date
    Sep 2002
    drop it and re-add it

  3. #3
    Join Date
    May 2002
    Setting unused is a one-way trip. The purpose of the feature is to "hide" the column for now and be able to drop it later when it is more convenient (implying that dropping the column involves large amounts of data, don't want to impact the database during the business day, etc.).

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.