Auto column width on edit table rows

Sergio Cascales Puerto 1 Reputation point

Version 18.10 of Management Studio. When edit first 200 rows (or all) i see the table columns not fit auto with its content. When doing new query i can see well but i can't edit rows.
Is there any way to autofit columns to its content with when edit table?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,070 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 27,136 Reputation points

    Is there any way to autofit columns to its content with when edit table?

    SSMS = "Management Studio" is a tool to manage SQL Server, not to edit data, the existing feature is just a small gimmick, nothing more.

  2. AmeliaGu-MSFT 13,891 Reputation points Microsoft Vendor

    Hi SergioCascalesPuerto-0477,

    Welcome to Microsoft Q&A.
    As Olaf said, unfortunately, SSMS doesn't yet support auto-size columns to fit the value width when editing table.
    You can submit your idea to the Microsoft feedback at this link:
    Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.

    Best Regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.