select schema_name from information_schema.schemata -- 查库select table_name from information_schema.tables where table_schema='' -- 查表select column_name from information_schema.columns where table_name='' -- 查列select * from 库名.表名;