This is a fast and simple way to find all tables in a SQL database which contains a specific column.
[sql]
SELECT COLUMN_NAME, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE ‘%MyColumn%’
[/sql]
Web development and technologies | egeek
ASP.NET, C#, Azure, SQL, Server, Umbraco, Sitecore, Git and other stuff I find useful
This is a fast and simple way to find all tables in a SQL database which contains a specific column.
[sql]
SELECT COLUMN_NAME, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE ‘%MyColumn%’
[/sql]