Skip to content

Instantly share code, notes, and snippets.

@ststeiger

ststeiger/View_Dependencies.sql

Created May 28, 2024 16:14
Show Gist options
  • Save ststeiger/a01d0c88aafeaaf9cc1a5cdaea373746 to your computer and use it in GitHub Desktop.
Save ststeiger/a01d0c88aafeaaf9cc1a5cdaea373746 to your computer and use it in GitHub Desktop.
Download ZIP
List view-dependencies in MS-SQL
Raw
View_Dependencies.sql
SELECT DISTINCT referenced_schema_name, referenced_entity_name
FROM sys.dm_sql_referenced_entities('dbo.V_COR_Objekte_Kategorien', 'OBJECT')
WHERE (1=1)
-- AND referenced_entity_name NOT IN('T_OV_Ref_ObjektTyp', 'T_SYS_ApertureColorToHex')
ORDER BY referenced_entity_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment