A Well needed Foreign key query for T-SQL

What is one of the biggest pains of troubleshooting data manipulation in a database? Foreign key constraints. So one guys posted in Stack Overflow a query that mines every foreign key constraint out of your database for you. However, he didn’t originate the query, his credit comes from this MSDN article.

So this is my gratitude to both sources of information.

SELECT
           KCU1.CONSTRAINT_NAME AS FK_CONSTRAINT_NAME
          ,KCU1.TABLE_NAME AS FK_TABLE_NAME
          ,KCU1.COLUMN_NAME AS FK_COLUMN_NAME
          ,KCU1.ORDINAL_POSITION AS FK_ORDINAL_POSITION
          ,KCU2.CONSTRAINT_NAME AS REFERENCED_CONSTRAINT_NAME
          ,KCU2.TABLE_NAME AS REFERENCED_TABLE_NAME
          ,KCU2.COLUMN_NAME AS REFERENCED_COLUMN_NAME
          ,KCU2.ORDINAL_POSITION AS REFERENCED_ORDINAL_POSITION
      FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KCU1
        ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG
       AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA
       AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KCU2
        ON KCU2.CONSTRAINT_CATALOG = RC.UNIQUE_CONSTRAINT_CATALOG
       AND KCU2.CONSTRAINT_SCHEMA = RC.UNIQUE_CONSTRAINT_SCHEMA
       AND KCU2.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME
       AND KCU2.ORDINAL_POSITION = KCU1.ORDINAL_POSITION