Post reply

Dependencies on a Column

  • June 6, 2012 at 9:01 am

    #262457

    Hello Everyone

    I know that one can use sp_depends, sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities to determine if a table name has dependencies, but what about a column in a table? Is there anything to tell me if a column in a table is actually being used in a query, view or function?

    Thank you in advance

    Andrew SQLDBA

  • June 6, 2012 at 9:05 am

    #1497683

    I knew that as soon as I posted this question, I would find the answer in the BOL

    read about "sys.dm_sql_referenced_entities" in the BOL

    Thanks

    Andrew SQLDBA

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply