View Table Dependencies Script(Table that depend on / Table on which depend)

OBJECT(TABLE) THAT DEPEND ON OBJECTS:

SELECT OBJECT_NAME(constraint_object_id)'CONS_NAME',
OBJECT_NAME(parent_object_id)'CHILD',
(select name from sys.columns where column_id=parent_column_id and object_id=parent_object_id)'CHILD_col',
OBJECT_NAME(referenced_object_id) 'PARENT',
(select name from sys.columns where column_id=referenced_column_id and object_id=referenced_object_id)'PARENT_COL'
FROM SYS.FOREIGN_KEY_COLUMNS
WHERE referenced_object_id =OBJECT_ID('TABLE NAME')

OBJECT(TABLE) ON WHICH OBJECTS DEPEND

SELECT OBJECT_NAME(constraint_object_id)'CONS_NAME',
OBJECT_NAME(parent_object_id)'CHILD',
(select name from sys.columns where column_id=parent_column_id and object_id=parent_object_id)'CHILD_col',
OBJECT_NAME(referenced_object_id) 'PARENT',
(select name from sys.columns where column_id=referenced_column_id and object_id=referenced_object_id)'PARENT_COL'
FROM SYS.FOREIGN_KEY_COLUMNS
WHERE parent_object_id =OBJECT_ID('TABLE NAME')