title: A SQL script to identify all the FKs referencing a table
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/483193/how-can-i-list-all-foreign-keys-referencing-a-given-table-in-sql-server-2005">How can I list all foreign keys referencing a given table in SQL Server 2005?</a>  </p>
  </blockquote>
  
  
  
  <p>I'm trying to use Information_Schema to find all the FKs referencing a particular table.  However I can only find the FKs that table holds onto others in the Constraint_Column_Usage and Constraint_Table_Usage tables.</p>
  
  <p>I'm using SQL Server 2008 </p>
  
  <p>How can I do this?</p>