Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010

    Unanswered: Query Regarding Dropping Column in DB2 V9.1

    Hi All,

    I need some information regarding dropping a column in DB2 V9.1 Version.
    Can anyone Please tell what are the effects of dropping a column(which is Primary Key of Table) in DB2 V9.1 Version?(The Table has a Index,View,trigger defined on it).Many Thanks in Advance.

  2. #2
    Join Date
    May 2003
    You cannot drop a column in version 9.1. That feature is provided in 9.7.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Quote Originally Posted by Marcus_A View Post
    You cannot drop a column in version 9.1.
    I think you can, actually. And the "effects" are clearly indicated in the manual, if madhuri228 endeavoured to read it.

Posting Permissions

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