Today I got tired of typing long SQL table names, so I figured I’d try Red-Gates’s SQL Prompt add-in for SQL Management Studio. I installed the trial version and in a matter of minutes got my first experience of “Intellisense” for SQL.

One word: Awesome!

The tool is really nice. It integrates very well into the environment, provides a ton of useful information, time saving features, and configuration options.

The demo version also includes a feature that formats the SQL code. This is pretty nice too. It makes everything the correct case, does proper line-break and indenting, etc.

To see it in action, check out their video based demo of SQL Prompt.