Re: all tables with certain type

[Gary Smith]

walter harms wrote:
> hi list,
> is it possible to get a list of all tables with a certain type in one statement ?
>
> for now i collect all tables  (show tables) and search for the type (show columns).
> Any way to circumvent that ? make it one statement ?
>   
use information_schema;

select column_name,data_type from columns where data_type='YOUR DATA 
TYPE HERE';

Gary