title: How can I list all foreign keys referencing a given table in SQL Server?
body: <p>I need to remove a highly referenced table in a SQL Server database.  How can I get a list of all the foreign key constraints I will need to remove in order to drop the table?</p>
  
  <p>(SQL answers preferable over clicking about in the GUI of the management studio.)</p>