reshuffle table-column in ssms

Shambhu Rai 1,406 Reputation points
2022-04-06T18:10:41.757+00:00

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 ...

190663-image.png

getting error message... any alternate option

![190607-image.png]2

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
Transact-SQL
Transact-SQL
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
    2022-04-06T18:15:19.237+00:00

    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