用如下sql即可: SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbName' 参考链接:http://www.itpub.net/thread-1064196-1-1.html