EM is essentially just running the script he is looking for under the
covers.. You will need to just create a new table (with columns in the
right order), dump all the data from the existing into the new table, drop
the old table and rename the newly created one to the original name.

I am curious though.. why does column position matter exactly? For
readability? You can pull the data however you want...

-----Original Message-----
From: J.Saraboji
[mailto:mssqldba-ezmlmshield-x68024078.[Email address protected]
Sent: Monday, December 31, 2007 2:25 AM
To: LazyDBA Discussion
Subject: column first





Dear Experts,





I need to add a column in table but that should be in
first. When I added the column in table it's come to last but I need that
column as first.

I required script only.





Note : In that alter statement I want to add column
description also.



Thanks in advance.





Thanks & Regards,

JSaraboji,

MSSQL - DBA Direction Software Solutions,

Contact : +91 22 66615000. EXT 336

E-Mail : j.[Email address protected]





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


The contents of this email are the property of the sender. If it was not addressed to you, you have no legal right to read it. If you think you received it in error, please notify the sender. Do not forward or copy without permission of the sender.

MS Sql Server LazyDBA home page