Let’s discuss one situation. There were so many tables in database and I have to change only one column of the table then how can I found this column is how many times used in any views or store procedure or any other database object. There is a ways to find this type of situation. First right click on the table and then click on dependency it will shows all the object that use this table but if I can see only that particular alter table column then there is no way to do that. After that problem I have found one solution that mention bellowed.
First create one table valued function CheckDependancy in your database.That function script define belowed.
After Creating this function fire a query like
This query will show all the view,store procedure or function name that use the companyname column. 🙂