Script like below :

SELECT
    OBJECT_NAME(referencing_id) AS [Referencing Entity],
    OBJECT_NAME(referencing_minor_id) AS [Referencing Minor Entity],
    referencing_class_desc AS [Referencing Entity Class],
    COL_NAME(referenced_id, referenced_minor_id) AS [Column],
    o.type_desc AS [Type],   
    COALESCE(COL_NAME(referencing_id, referencing_minor_id), '(n/a)') AS [Column],

    referenced_server_name AS [Referenced Server],
    referenced_database_name AS [Referenced DB],
    referenced_schema_name AS [Referenced Schema],
    referenced_entity_name AS [Referenced Entity],
    referenced_class_desc AS [Referenced Entity Class] ,
    (select type from sys.objects where  object_id = referenced_id ) AS [Type],   
    COALESCE(COL_NAME(referenced_id, referenced_minor_id), '(n/a)') AS [Column]
FROM 
    sys.sql_expression_dependencies sed
INNER JOIN 
    sys.objects AS o 
ON 
    sed.referencing_id = o.object_id 
WHERE 
    referenced_id = OBJECT_ID('')
    or referencing_id = OBJECT_ID('')
/*  
SELECT
    referenced_server_name
    referenced_database_name ,
    referenced_schema_name ,
    referenced_entity_name ,
    referenced_class_desc,
FROM sys.sql_expression_dependencies
WHERE 
    referenced_id = OBJECT_ID('')
    or referencing_id = OBJECT_ID('')
 */

• ← Maintenance Solution - SQL Server
• Get Table Or View Column With Type - SQL Server →