SELECT table_name from information_schema.columns
where TABLE_SCHEMA='DBName' and COLUMN_NAME='columnName'
解释一下:
DBName: 要查询的数据库名称;
columnName: 你所知道的列;