mysql
select SCHEMA_NAME from information_schema.SCHEMATA //获取所有的schema 数据库
SELECT TABLE_NAME from information_schema.`TABLES` where TABLE_SCHEMA = 'world';//查询指定schema的所有表名
select * from information_schema.COLUMNS where TABLE_NAME = 'city' //查询指定表对应的列信息