There are 3 options available for the Query Results
Results to Text Ctrl + T
Results to Grid Ctrl + D
Results to File Ctrl + Shift + F
Currently your results are showing in Text mode. Changing it to Grid mode, you need to press Ctrl + D or simply select the option as in the screenshot below:
More over, if you are regularly using the
sp_columns to get the column details, you can add it as keyboard shortcut by
Tools -> Options -> Environment -> Keyboard -> Query Shortcuts.
In the option you can place the
sp_columns against the not reserved columns. For an example, I place in the against Ctrl+3.
So the next time you type the tablename in the query analyzer and Press Ctrl + D then Ctrl + 3 you will get your expected result.