We have a scenario wherein we need to identify where all a column of a particular table is being used and which all tables would be impacted from the same.
eg: col 1 of table t1 is being dropped
1) there is a stored procedure which populates table t2 and within that stored procedure, column c1 of table t1 is being used.
insert into t2 (c2)
c1 as 'c2'
Now, verify column dependency via SSMS would only provide me the objects names like table t1, Stored procedure or those tables having PK-FK relationships .
but it wont provide me that table t2 would also be impacted dynamically.
We have to manually go and analsye the stored procedure.
So is there any automated way or any tool via which we can get the required results