Answers for "sql server find all referencing objects to user-defined table type"

SQL
0

sql server find all referencing objects to user-defined table type

-- Find all referencing objects to user-defined table type
SELECT ROW_NUMBER() OVER (ORDER BY OBJECT_NAME(m.object_id)) RowId, definition
FROM sys.sql_expression_dependencies d
JOIN sys.sql_modules m ON m.object_id = d.referencing_id
JOIN sys.objects o ON o.object_id = m.object_id
WHERE referenced_id = TYPE_ID('NAME_OF_TABLE_TYPE')
Posted by: Guest on May-03-2022

Code answers related to "sql server find all referencing objects to user-defined table type"

Code answers related to "SQL"

Browse Popular Code Answers by Language