title: SQL Server Column Dependencies without Deprecated SYS View
body: <p>I am gathering information about dependencies from "objects" down to the column level (e.g. stored procedure X uses Table A columns C0 and C1).</p>
  
  <p>I have found that my SQL Server 2012 database gives me column-level dependency information via sys.sql_dependencies (because column referenced_minor_id is not identically zero) and it does NOT give me column-level dependency information via sys.sql_expression_dependencies (because column referenced_minor_id IS identically zero).</p>
  
  <p>The <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-dependencies-transact-sql" rel="nofollow noreferrer">docs</a> say sys.sql_dependencies is deprecated in favor of sys.sql_expression_dependencies however it looks as if the "newer" view does not provide column level info (even though it appears to have a column for that purpose).</p>
  
  <p>My conclusion is that in some future version of SQL Server I will be unable to get column level dependency information. Is my conclusion incorrect due to some piece of information I haven't mentioned?</p>