SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘数据库名‘ select table_schema,table_name,column_name from information_schema.columns order by table_schema,table_name
mysql 查询表相关信息
原文：http://www.cnblogs.com/zt528/p/5291869.html
