How to Change Ordinal position in sql server Table

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts

How to get the exact property name while getting error (0)
PDB file is not showing Line Number in dot net application hosted on server (0)
Both Strings morethan 5 letters in length end of the words one vowel and one consonent is different (0)
how to check Any adjacent letters transposed between two strings(ex: JOHN, JHON) (1)
can't receive data after success login ? (1)
Implement Multi-Tenant in Azure Logic Apps (0)
Why ASP.Net Core 7.0 Web API showing as Connection refused? (0)
Iterating over columns of dataframe and print as rows in Python Django (0)
More ...