![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 17%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
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 ?
Auto column width on edit table rows
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 99%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sergio Cascales Puerto
11
Reputation points
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 | Other
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff2022-02-14T01:29:27.897+00:00 Hi SergioCascalesPuerto-0477,
How are things going? Do the answers help you?
Please feel free to let us know if you have any other question.
If the post in the thread is helpful, you could kindly accept it as answer.Best Regards,
Amelia
Sign in to comment
3 answers
Sort by: Most helpful
-
-
Olaf Helper 47,581 Reputation points2022-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. -
AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
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.