Skip to content

Instantly share code, notes, and snippets.

@DocGreenRob

DocGreenRob/sql power tools

Last active May 22, 2024 06:38
Show Gist options
  • Save DocGreenRob/b8074db95dc0017ad80224c9740ea9c9 to your computer and use it in GitHub Desktop.
Save DocGreenRob/b8074db95dc0017ad80224c9740ea9c9 to your computer and use it in GitHub Desktop.
Download ZIP
Find references in all Columns and Tables
Raw
sql power tools
SELECT column_name,
table_name,
table_schema
FROM information_schema.columns
WHERE column_name LIKE '%calendar%'
AND table_schema IN ( 'dbo' )
ORDER BY table_name, column_name
@DocGreenRob
Copy link
Author 

[Azure Data Factory | Copy multiple tables in Bulk with Lookup & ForEach](https://www.youtube.com/watch?v=KsO2FHQdILs)

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