How to: Autosize Selected Tables in Diagrams (Visual Database Tools)
You can quickly fit tables in your diagram to the smallest size that shows all fields.
To automatically size selected tables in diagrams
Select the table(s) you want to resize.
Right click a selected table and from the shortcut menu choose Autosize Selected Tables.