Column Insert



IBM's flagship relational database management system

Column Insert

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

Hi
i have a requirement. I have 5 columns in a Table.
like
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.
jash
 
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

Hello,

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,
d.sch.
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
    Replies
    Views
    Last post