Get Columns and Tables Contain Word

Get columns and tables contain word

select name as columnName,object_name(object_id)as tableName from sys.columns where object_id in
(select object_id from sys.tables where name like '%account%') and name like '%_%' order by tablename