SQL SERVER – Tracking Database Dependencies

If database changes are needed to be made at a column level, it’s essential that you perform impact assessment in order to determine which objects will be affected after the change. This means that SQL table column dependencies within a database need to be analyzed.

ApexSQL Clean is a tool that is used to analyze SQL server database dependencies and also to remove unwanted objects.

To analyze table column dependencies within a SQL database the first thing you need to do is to create a new project. That can be done by clicking the New button in the Home tab and choosing the desired server and the database.

Read More