How to search for a specific column name from all tables in SQL?

select * from INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME like '%ReplaceWithYourColumnName%'
order by TABLE_NAME

2018-01-01

index