Sometimes you want to rename or delete column from a table in MS SQL Server. How to find column name dependency usage in MS SQL Server? There is no clean way of doing this. In management studio you can right click on object and select "View Dependency", but this would show only object dependency. So you need to write some T-SQL code in order to find dependency. Lets say we need to find dependecy of Title column from the Article table.
SELECT DISTINCT so.name
FROM sys.syscomments sc
INNER JOIN sys.objects so on sc.id=so.object_id
WHERE sc.text LIKE '%Title%'