ApexSQL Search

ApexSQL Search analyzes SQL Server database object's dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. Search for SQL objects directly in SSMS and MSVS, quickly find data in SQL tables and views, visualize complex relationships between objects, and rename SQL objects without breaking dependencies.

Features:

- SQL objects’ extended properties can now be edited visually using the extended property editor

- SQL Server 2016 support: Search for objects or text directly in SQL Server 2016 Management Studio

- Object search: Search for objects or text in database object definitions

- Text search: Search for text, numbers, dates and unique identifiers in your tables and views

- Graphical dependencies: Visualize even the most complex relationships between SQL objects

- Safe rename: Rename tables, procedures, views, functions and columns without breaking dependencies

- Search history: Quickly access previously searched objects with automatically saved searches

- Recognizes and accurately processes all objects' interdependencies

- Customizable searches: Specify the object types to be searched

- Navigate to Object Explorer node: Navigate to the found object in a single click

- Results browsing: Group, sort and filter search results

- Transparent description: Search, rename or identify encrypted objects dependencies. Search for data in encrypted views

- Visual Studio integration: Supports Visual Studio 2017, 2015 2013, 2012 and 2010

- Support for all SQL Server versions: Full support for SQL Server 2017 CTP 2, 2016, 2014, 2012, 2008 R2, 2008 and 2005 objects and data