Auto column width on edit table rows

Sergio Cascales Puerto 11 Reputation points
2022-02-09T08:14:36.27+00:00

Hello
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?
Thanks

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

3 answers

Sort by: Most helpful
  1. Olaf Helper 41,021 Reputation points
    2022-02-09T08:21:53.487+00:00

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

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

    0 comments No comments

  2. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2022-02-09T09:13:11.783+00:00

    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: https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0
    Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.

    Best Regards,
    Amelia


    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.

    0 comments No comments

  3. Marc Roussel 0 Reputation points
    2024-01-23T15:07:51.4033333+00:00

    What is going on here ? Before my laptop was connected to an LG TV at a lower resolution and now I'm at 3840 x 2160 and because of that, SSMS when you EDIT TOP 200 rows, all columns width are too short to see. VERY SHORT in fact. Way more than before. So what's the deal here ?

    0 comments No comments