Query table usage

Today I needed to figure out how to find all the views and tables referencing a particular table. With help from coworkers and google I came up with the following script:

SELECT VIEW_CATALOG,VIEW_SCHEMA,VIEW_NAME,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME, '' AS COLUMN_NAME
from INFORMATION_SCHEMA.VIEW_TABLE_USAGE AS VTU1
WHERE VTU1.TABLE_NAME = 'TABLE_NAME'
UNION
select VIEW_CATALOG,VIEW_SCHEMA,VIEW_NAME,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE AS VTU2
WHERE VTU2.COLUMN_NAME IN
(SELECT
CU.COLUMN_NAME
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
INNER JOIN (
SELECT i1.TABLE_NAME, i2.COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
WHERE i1.CONSTRAINT_TYPE = 'PRIMARY KEY'
) PT ON PT.TABLE_NAME = PK.TABLE_NAME
WHERE PK.TABLE_NAME='TABLE_NAME')

First part of the script identifies all direct references of the table you are querying against. The second part, identifies any foreign key references to the same table, and then queries for any views that are using those foreign keys.

Let me know if you find this useful.

References:
1. VIEW_TABLE_USAGE
2. Query to Display Foreign Key Relationships