Would you like to write maintainable SQL scripts and understand code faster? SqlSmash is a plugin for SQL Server Management Studio (2012 and 2014) that enables those things and faster navigation. You can use it with SQL Server (from 2005 to 2014) as well as Azure SQL.
SqlSmash is perfect for novice developers and experts alike, with support for configurable keyboard shortcuts, toolbars and contextual menus.
Search all your database objects for any text. View definition for matching objects, select them in Object Explorer and Copy results in an Excel friendly format.
Get a flat list of objects referencing the SQL Object under your cursor and navigate to them in Object Explorer.
Get a quick overview with information like column and parameter names and types for the SQL Object under your cursor.
It's fairly tedious to locate an object in Object Explorer (expand, expand, expand, pick folder, scan objects). Now you can easily navigate to any table, stored procedure, function or trigger in only a few keystrokes.
Deal with long or complex scripts? Now you can summarize them in a hierarchial manner and navigate the code easily and quickly.
Make your code more readable and maintainable by indenting it and applying your casing preferences.
No need to select text to run one query anymore. With a single click, now you can execute the query around your cursor.
Show the definition of a SQL Object in a single click.