Monday, December 20, 2010

Mysql db count tables

select count(*) as number_of_tables 
from information_schema.tables 
where table_schema = 'my favourite schema' 


No comments:

Blog Archive