adding column in between

[nisha23]

Command -- (Alter Table
add col....)

Can I add column instead of end in between?

 

[vongrunt]

Yes, in mySQL .

I'm afraid not - unless you drop and recreate entire table, which EM already does (not recommended on larger tables in production database in any case).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[nisha23]

I am working in Microsoft Sql Server.
I don't want to drop table, that means the only option is to add at the end.

 

[vongrunt]

If ordinal position of columns really matters (aesthetical reasons or whatever), do it with EM - preferably during development phase, when tables are small. Data won't be lost.



------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)