How do you identify all stored procedures referencing a specific table

✅ SQL Server

SELECT DISTINCT 
    OBJECT_NAME(sm.object_id) AS ProcedureName
FROM 
    sys.sql_modules sm
JOIN 
    sys.objects o ON sm.object_id = o.object_id
WHERE 
    sm.definition LIKE '%YourTableName%'
    AND o.type = 'P';  -- 'P' = Stored Procedure

✅ MySQL

SELECT 
    ROUTINE_NAME, ROUTINE_TYPE
FROM 
    INFORMATION_SCHEMA.ROUTINES
WHERE 
    ROUTINE_DEFINITION LIKE '%YourTableName%'
    AND ROUTINE_TYPE = 'PROCEDURE';

Note: For large procedures, ROUTINE_DEFINITION may be truncated. Use SHOW CREATE PROCEDURE ProcedureName for full content.

✅ PostgreSQL

SELECT 
    proname
FROM 
    pg_proc
JOIN 
    pg_namespace n ON n.oid = pg_proc.pronamespace
WHERE 
    pg_get_functiondef(pg_proc.oid) LIKE '%YourTableName%';

✅ Oracle

SELECT 
    NAME, TYPE
FROM 
    ALL_SOURCE
WHERE 
    UPPER(TEXT) LIKE '%YOURTABLENAME%'
    AND TYPE = 'PROCEDURE';