• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

SQL 2005 Column Width

when you right click on a table name in SQL and select open, if the column titles are too long to display completely, SQL adds ... on the end of the column name.  Is there a way to tell SQL to widen all the columns wide enough to display the complete column name?  
I am not referring to widening the column width to the data in the rows but the column name.
2 Solutions
Raja Jegan RSQL Server DBA & ArchitectCommented:
Just double click on the column name in Designer window so that it would expand to fit entire column name..
Since this is something related to GUI, there is no default settings that can be done for this.
dastaubAuthor Commented:
once the column has been expaned, can it be saved that way.
DBAduck - Ben MillerPrincipal ConsultantCommented:
No it doesn't work that way for that operation.  There would be way too much context to keep for every right-click open operation performed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now