CODE EXAMPLE FOR SQL

how to find column in all the tables sql

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