List:General Discussion« Previous MessageNext Message »
From:Gary Smith Date:December 14 2009 5:28pm
Subject:Re: all tables with certain type
View as plain text  
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
Thread
all tables with certain typewalter harms14 Dec
  • Re: all tables with certain typeGary Smith14 Dec