Show all tables where table name contains ‘log’

Select * From INFORMATION_SCHEMA.TABLES
Where
table_name LIKE '%log%'
AND
table_name NOT LIKE '%catalog%'

Show table columns with a specified name:

Use DatabaseName
Select*From INFORMATION_SCHEMA.COLUMNS Where column_name ='ColName'

sql – I want to show all tables that have specified column name – Stack Overflow.