insert a field

How do you insert a field to an existing table to certain position using
Enterprise Master - SQL 2000?

Hi
It does not make sense since when you select the columns you can order them
as you want , however ifyou want to add the column so select the position
and right click and insert column from the pop menu





"00Eric Clapton" <a@b.com> wrote in message
news:Oti5ZSnkFHA.3756@TK2MSFTNGP15.phx.gbl...
> How do you insert a field to an existing table to certain position using
> Enterprise Master - SQL 2000?
>

Hi,

You cant do that. SQL Server always insert the field at the end. The only
way to include the field in middle is by dropping and recreating the
table structure.

Thanks
Hari
SQL Server MVP

"00Eric Clapton" <a@b.com> wrote in message
news:Oti5ZSnkFHA.3756@TK2MSFTNGP15.phx.gbl...
> How do you insert a field to an existing table to certain position using
> Enterprise Master - SQL 2000?
>

Thanks, Uri. I didn't know it is that easy. Cheers.

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OBxD8ankFHA.4000@TK2MSFTNGP12.phx.gbl...
> Hi
> It does not make sense since when you select the columns you can order
> them as you want , however ifyou want to add the column so select the
> position and right click and insert column from the pop menu
>
>
>
>
>
> "00Eric Clapton" <a@b.com> wrote in message
> news:Oti5ZSnkFHA.3756@TK2MSFTNGP15.phx.gbl... 
>
>

Uri,

But Enterprise manager will drop and recreate the table for this. Assume if
we are going to do this for a huge table!!!!

Thanks
Hari
SQL Server MVP


"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OBxD8ankFHA.4000@TK2MSFTNGP12.phx.gbl...
> Hi
> It does not make sense since when you select the columns you can order
> them as you want , however ifyou want to add the column so select the
> position and right click and insert column from the pop menu
>
>
>
>
>
> "00Eric Clapton" <a@b.com> wrote in message
> news:Oti5ZSnkFHA.3756@TK2MSFTNGP15.phx.gbl... 
>
>

Hari
> How do you insert a field to an existing table to certain position using
> Enterprise Master - SQL 2000?

This was the OP question

You are absolutely right and I don't use EM for such purposes at all. It
seems that OP is completely new to  SQL Server unless he/she would has done
vs QA


"Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
news:%237U2ZknkFHA.3212@TK2MSFTNGP10.phx.gbl...
> Uri,
>
> But Enterprise manager will drop and recreate the table for this. Assume
> if we are going to do this for a huge table!!!!
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:OBxD8ankFHA.4000@TK2MSFTNGP12.phx.gbl... 
>
>

Ok Uri.... I understood.

Thanks
Hari

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:e8lWconkFHA.3960@TK2MSFTNGP12.phx.gbl...
> Hari 
>
> This was the OP question
>
> You are absolutely right and I don't use EM for such purposes at all. It
> seems that OP is completely new to  SQL Server unless he/she would has
> done vs QA
>
>
> "Hari Prasad" < hari_prasad_k@hotmai
l.com> wrote in message
> news:%237U2ZknkFHA.3212@TK2MSFTNGP10.phx.gbl... 
>
>