References of a table in a BD

References of a table in a BD

DECLARE @SearchText NVARCHAR(255) = 'table_name';

SELECT 
    OBJECT_SCHEMA_NAME(sm.[object_id]) AS [Schema],
    OBJECT_NAME(sm.[object_id]) AS [ObjectName],
    o.type_desc AS [ObjectType],
    sm.[definition] AS [SQLDefinition]
FROM sys.sql_modules sm
INNER JOIN sys.objects o ON sm.[object_id] = o.[object_id]
WHERE sm.[definition] LIKE '%' + @SearchText + '%'
ORDER BY [Schema], [ObjectName];