select column_name, data_type, character_maximum_length from information_schema.columns 
where table_name = 'grasshopper' 
and column_name like '%id%'