Change the text that appears on tabs in SQL Server Management Studio
When you start SQL Server Management Studio, select Options from Tools in the menu.
From the menu on the left, you can choose Text Editor - Editor Tabs and Status Bar and select what you want to display from the Tab Text group on the right.
In the figure, it will be displayed when only "Include file name" is enabled. The tab width has been narrowed, allowing many files to be kept in tabs.