Auto column width on edit table rows

Sergio Cascales Puerto 1 Reputation point
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.
9,070 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 27,136 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.

  2. AmeliaGu-MSFT 13,891 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.