SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE T(id int IDENTITY, v varchar(30))
CREATE PROC p1
AS

INSERT T DEFAULT VALUES
CREATE PROC p2
AS

UPDATE dbo.T
SET v = '';
CREATE PROC p3
AS

DELETE T;
CREATE PROC p4
AS

TRUNCATE TABLE T;
CREATE PROC p5
AS

DROP TABLE T;
SELECT
  schema_name = s.name,
  p.name,
  is_updated = CAST(
      CASE WHEN EXISTS (SELECT 1
        FROM sys.dm_sql_referenced_entities(QUOTENAME(s.name) + '.' + QUOTENAME(p.name), 'OBJECT') r
        WHERE r.is_updated = 1)
      THEN 1 ELSE 0 END
    AS bit)
FROM sys.procedures p
JOIN sys.schemas s ON s.schema_id = p.schema_id
WHERE p.is_ms_shipped = 0;


schema_name
name
is_updated


dbo
p1
True

dbo
p2
True

dbo
p3
True

dbo
p4
False

dbo
p5
False