Page 1 of 1

Column Insert

PostPosted: Fri Mar 05, 2010 9:03 am
by jash
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.

Re: Column Insert

PostPosted: Fri Mar 05, 2010 9:36 am
by dick scherrer
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.