스키마내 테이블 수

원형>

SELECT count(*) FROM information_schema.tables WHERE table_schema = '스키마이름'

예>

SELECT count(*) AS number_of_tables FROM information_schema.tables WHERE table_schema = 'test5'