An easier Table Design View in Sql Server Management Studio

Why not join our community?, there are 9 users online

home
database
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

29
kicks

kick it

An easier Table Design View in Sql Server Management Studio

published 7 months, 12 days ago, submitted by

rstrahl 7 months, 12 days ago

west-wind.com — One of the things that bugs me no end in Sql Server Management Studio is that the table designer's UI is a pain to use. Entering column properties is an excercise in mousercise. It turns out there's an easier way to do this with custom views in the DataBase Diagram Designer.

3 comments | category:

Database | Views: 4 | Get KickIt image code

tags: Database | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

rstrahl -

yesthatmcgurk -

HoolieMan - ormico -

justin_etheredge -

TroyMG - zvikara -

davehogue - BlackWasp - adventurer - senfo -

powerrush -

atifaziz - bdsutton -

ColinCochrane -

stupid -

wisemx - bzbetty -

johnrummell - pmbrown - immothep -

mdopp - antny -

diamondz - smallfox - khushal999p - samdnp - cheetahtech - dotnetter

Comments:

Extremely true story, Rick. I would consider two of my developer friends SQL Server "experts", and they mock me fiercely when I talk about using the diagram designer. They always want to know how I could possibly get by without typing the DML into scripts myself. I guess because I'm not a masochist? I love the diagram designer, and I'm not afraid to admit it (anymore)!! ;)

posted by jesse 7 months, 10 days ago

Arg, DDL. What a rook ;)

posted by jesse 7 months, 10 days ago

I've done some experimenting with SQLCE (Compact Edition) and the Microsoft GUI is horrible. SQL Server Management Studio is much nicer but SQLCE 3.0 isn't supported there. I am always looking for better ways to look at the information, and this looks better than many.

posted by samdnp 7 months, 9 days ago