SqlServer. Lista de tablas y tablas relacionadas (Foreing key)

Lista de tablas

select * from sys.all_objects where type like 'U'

Tablas relacionadas con una dada.

SELECT   
   distinct OBJECT_NAME (f.referenced_object_id) AS referenced_object  
   FROM sys.foreign_keys AS f  
   WHERE f.parent_object_id = OBJECT_ID('[Nombre_tabla]');