SELECT
    OBJECT_SCHEMA_NAME(object_id) AS SchemaName,
    OBJECT_NAME(object_id) AS ObjectName
FROM sys.sql_modules
WHERE definition LIKE '%SearchColumn%';

SELECT
    TABLE_SCHEMA,
    TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE VIEW_DEFINITION LIKE '%SearchColumn%';

SELECT
    CategoryName AS SearchColumn
FROM dbo.Products;

SELECT
    OBJECT_SCHEMA_NAME(o.object_id) AS SchemaName,
    o.name AS ObjectName,
    o.type_desc AS ObjectType
FROM sys.objects AS o
INNER JOIN sys.sql_modules AS m
    ON o.object_id = m.object_id
WHERE o.type IN ('FN', 'IF', 'TF')

  AND m.definition LIKE '%SearchColumn%';

RETURN CONCAT(@ProductName, ' ', @CategoryName);

SELECT
    OBJECT_SCHEMA_NAME(object_id) AS SchemaName,
    OBJECT_NAME(object_id) AS TriggerName
FROM sys.sql_modules
WHERE definition LIKE '%SearchColumn%'

  AND OBJECTPROPERTY(object_id, 'IsTrigger') = 1;

UPDATE dbo.Productsearch
SET SearchColumn = i.CategoryName
FROM inserted AS i;

SELECT
    OBJECT_SCHEMA_NAME(object_id) AS SchemaName,
    OBJECT_NAME(object_id) AS TableName,
    name AS ColumnName
FROM sys.columns
WHERE name = 'SearchColumn';

SELECT
    SCHEMA_NAME(t.schema_id) AS SchemaName,
    t.name AS TableName,
    c.name AS ColumnName,
    cc.definition AS ComputedDefinition,
    cc.is_persisted AS IsPersisted
FROM sys.computed_columns AS cc
INNER JOIN sys.columns AS c
    ON cc.object_id = c.object_id
   AND cc.column_id = c.column_id
INNER JOIN sys.tables AS t
    ON cc.object_id = t.object_id
WHERE c.name = 'SearchColumn';

SELECT
    o.type_desc AS ObjectType,
    OBJECT_SCHEMA_NAME(o.object_id) AS SchemaName,
    o.name AS ObjectName
FROM sys.sql_modules AS m
INNER JOIN sys.objects AS o
    ON m.object_id = o.object_id
WHERE m.definition LIKE '%SearchColumn%'

ORDER BY
    o.type_desc,
    o.name;