Skip to content

Instantly share code, notes, and snippets.

@jrichardsz

jrichardsz/devops sql - cdn.md

Last active October 1, 2024 23:48
Show Gist options
  • Save jrichardsz/ad78c90f7d9925ccb26bc2a5f3e7e95a to your computer and use it in GitHub Desktop.
Save jrichardsz/ad78c90f7d9925ccb26bc2a5f3e7e95a to your computer and use it in GitHub Desktop.
Download ZIP
devops sql
Raw
devops sql - get table dependencies.md

sql server

SELECT
OBJECT_NAME(fkeys.constraint_object_id) foreign_key_name ,OBJECT_NAME(fkeys.parent_object_id) referencing_table_name ,COL_NAME(fkeys.parent_object_id, fkeys.parent_column_id) referencing_column_name ,OBJECT_SCHEMA_NAME(fkeys.parent_object_id) referencing_schema_name ,OBJECT_NAME (fkeys.referenced_object_id) referenced_table_name ,COL_NAME(fkeys.referenced_object_id, fkeys.referenced_column_id) referenced_column_name ,OBJECT_SCHEMA_NAME(fkeys.referenced_object_id) referenced_schema_name FROM sys.foreign_key_columns AS fkeys WHERE OBJECT_NAME(fkeys.parent_object_id) = 'table_name' AND OBJECT_SCHEMA_NAME(fkeys.parent_object_id) = 'schema_name'

https://stackoverflow.com/a/52924297/3957754

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment