No, there is no way to make Management Studio do that. You've opened a query window, and you can customize what is displayed there, but table name is not one of the choices. After all, a small number of queries involve only one table. And think about these questions:
- If you add another query to that window, what should the title become?
- If you change the query it produced to be a join, what then?
- If you've saved the query as some file, should the table name override the name you gave?
These questions are rhetorical, since the functionality is not possible anyway, but there are many other technical considerations that go far beyond right-clicking a table and saying
SSMSBoost seems to give you some control over these things, but I don't see table name as being an option here either (probably for the same technical challenges I raised in my bullets).