查询数据库表字段名和有哪些表

查询表字段

select column_name from information_schema.COLUMNS where TABLE_SCHEMA = (select database()) and TABLE_NAME='xbr_config_out_datasource'

查询数据库表

select table_name from information_schema.TABLES where TABLE_SCHEMA=(select database())