reshuffle table-column in ssms

Shambhu Rai 1,406 Reputation points

Hi Expert,
how to reshuffle column in ssms design mode. I want to make fieldname as first column but unable to do it on design mode ...


getting error message... any alternate option


Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,046 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,575 questions
{count} votes

Accepted answer
  1. Viorel 113.7K Reputation points

    Try unselecting the "Prevent saving changes that require table re-creation" option. (See menu, Tools, Options, Designers, Table and Database Designers).

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful