Schema compare and dependencies
Posted: Fri 12 May 2017 14:14
Hi,
Is there a way to configure schema compare so it shows the dependencies for an object being changed. For example I have table passenger that has an SP that depends on it. If I rename the table to passengers, I dont see any warning in the IDE or with the source control module in SSMS telling me there is an SP referencing the table. Furthermore, if I modify the SP to and do a schema compare and chose only the table, I get no warning about including the SP in the change so it doesn't break the build.
Am I missing something?
Is there a way to configure schema compare so it shows the dependencies for an object being changed. For example I have table passenger that has an SP that depends on it. If I rename the table to passengers, I dont see any warning in the IDE or with the source control module in SSMS telling me there is an SP referencing the table. Furthermore, if I modify the SP to and do a schema compare and chose only the table, I get no warning about including the SP in the change so it doesn't break the build.
Am I missing something?