Life & Technology

Handful lessons in different areas of technology and life in general.

Design a Table in SQL Management Studio with ease

Recently, Rick Strahl blog about how we can use Database Diagram Designer as an alternative way to design our table. This is in fact, saves a lot of time as compared with the default Table Design window that SMSE offers. Read his cool article at Easier Table Design in SMSE.

I would just like to add on his cool trick the ability to just save the table and not the Diagram. We can achieve this by actually clicking the File/Save Selection menu but it will be much easier if we can just click an icon rather than going to Menu toolbar, isn’t?

Just go to Tools/Customize or just right-click the open space on the icon toolbars and click Customize. On the Categories, choose File and on the right pane, go down until you see the Save Selection command. Just drag the command beside your Save All icon and there you have it!

customize

Your toolbar will look like this:

customize2

Leave a comment