Created
October 9, 2019 20:08
-
-
Save maxkoshevoi/e0a254a25025c9d59a3efd940c9b01f3 to your computer and use it in GitHub Desktop.
Search for column with specific name in MSSQL database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT c.name AS 'ColumnName' | |
,t.name AS 'TableName' | |
FROM sys.columns c | |
JOIN sys.tables t ON c.object_id = t.object_id | |
WHERE c.name LIKE '%email%' | |
ORDER BY TableName | |
,ColumnName; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment