Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    5

    Unanswered: Is it possible to change column name of existing table?

    10'x in advanced,
    Mayam.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Not without rebuilding the table.

    Andy

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Quote Originally Posted by mayam
    Is it possible to change column name of existing table
    Code:
    ALTER TABLE tblname RENAME COLUMN colname TO newcolname
    (At least, when you are on DB2 9 for z/OS.)
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by Peter.Vanroose
    Code:
    ALTER TABLE tblname RENAME COLUMN colname TO newcolname
    (At least, when you are on DB2 9 for z/OS.)
    With LUW, that does not exist.

    Andy

Posting Permissions

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