Skip to content

Instantly share code, notes, and snippets.

@dlgombert

dlgombert/view_finder.sql

Created April 14, 2022 13:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dlgombert/78847de686e909b0e0839ea65bf3c5e5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dlgombert/78847de686e909b0e0839ea65bf3c5e5 to your computer and use it in GitHub Desktop.
Download ZIP
[sql view column finder] Finds columns in sql server views #tsql
Raw
view_finder.sql
SELECT
DISTINCT OBJECT_DEFINITION(sv.object_id)
FROM
sys.views sv
JOIN sys.columns sc ON (sv.object_id = sc.object_id)
WHERE
sc.name LIKE '%#{$1:COLUMN_NAME_SUBSTRING}%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment