title: Query to find all FK constraints and their delete rules (SQL Server)
body: <p>In SQL Server 2005, can I issue an SQL query to list all FK constraints on tables within the DB, and show the delete rule? (ie nothing, cascade, set null, or set default)</p>
  
  <p>The output I'm looking for is something akin to:</p>
  
  <pre><code>FK_NAME                  ON_DELETE
  ==================================
  FK_LINEITEM_STATEMENT    CASCADE
  FK_ACCOUNTREP_CLIENT     NOTHING
  </code></pre>