ApexSQL Clean

ApexSQL Clean is a robust software that enables you to analyze SQL Server database objects, dependencies across applications, databases, and scripts. The software can identify all database dependencies, even those that SQL Server fails to recognize. Using ApexSQL Clean, you can easily remove unwanted objects with no risk and map dependencies down to the table column level with ease.

The software also lets you specify database processing criteria, check or ignore the relationships for specific objects, and create end-user reports to document the interdependencies in your environments. It is possible to schedule unattended SQL dependency checking using the command-line interface.

ApexSQL Clean comes with support for SQL Server 2016, and all other SQL Server versions, including 2014, 2012, 2008, 2005. This means you can easily analyze SQL Server 2016 object relationships and identify various dependencies, including FileTable, sequence, search property list, column, store index, poison message, handling attribute for queues, as well as geometry and geography auto grid tessellation scheme for spatial indexes dependencies.

Overall, ApexSQL Clean is a versatile tool that every developer or database administrator should consider using to improve SQL Server database object management and dependencies across applications, databases, and scripts.