Column Insert

IBM's flagship relational database management system

Column Insert

Postby jash » Fri Mar 05, 2010 9:03 am

i have a requirement. I have 5 columns in a Table.
C1 C2 C3 C4 C5
i want to insert a new column in between C2 and C3 how do it .What could be the query>
Please give me some suggestion.

Thanks in Advance.
Posts: 12
Joined: Sun Oct 04, 2009 12:05 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Column Insert

Postby dick scherrer » Fri Mar 05, 2010 9:36 am


Change the CREATE TABLE, but there is probably no reason to do so. . .

Why do you care that this new column be defined between c2 and c3? When columns are used in a query, there is no necessary placement.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Return to DB2


  • Related topics
    Last post