Skip to content

Instantly share code, notes, and snippets.

@martea

martea/sql_search_column_script.sql

Last active August 30, 2018 11:33
Show Gist options
  • Save martea/8071e28cc29de9038cf96ca6089554d9 to your computer and use it in GitHub Desktop.
Save martea/8071e28cc29de9038cf96ca6089554d9 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Search for columns ids
Raw
sql_search_column_script.sql
SELECT COLUMN_NAME AS 'ColumnName'
,TABLE_NAME AS 'TableName'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%EntityId%'
ORDER BY TableName
,ColumnName;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment