语句如下: [sql] view plain copy SELECT count(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA='dbname'; 其中dbname是要查看的数据库的名字。 查看表结构: [sql] view plain copy description tbname; 也可使用简写: [sql] view plain copy desc tbname;