find tables in sql server that have a column name code example
Example 1: sql server search column name in all tables
SELECT COLUMN_NAME AS 'ColumnName'
,TABLE_NAME AS 'TableName'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%MyName%'
ORDER BY TableName
,ColumnName;
Example 2: sql server find table name
select * from sys.tables where name like '%tablename%'