How to Change Ordinal position in sql server Table

Posted by Jayakumars under Sql Server on 3/26/2013 | Points: 10 | Views : 3537 | Status : [Member] [MVP] | Replies : 1
hi

How to Change Ordinal position in sql server Table after creation table structure.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com



Responses

Posted by: Prateekagra on: 3/29/2013 [Member] Starter | Points: 25

Up
0
Down
if you wish to change in the existing table then you can do it from designed interface of table .simply drag and drop the column according to your order.

but this is not suggested as it will impact the object id of columns

it better to create another table as per your requirement

Prateek Agarwal
DBA

Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response