I think you want SELECT * FROM INFORMATION_SCHEMA.TABLES
See http://dev.mysql.com/doc/refman/5.0/en/tables-table.html
More Related Contents:
- How to select column names dynamically in mySQL
- MySQL: Return 2 different result together
- Get top n records for each group of grouped results
- Insert into a MySQL table or update if exists
- need to return two sets of data with two different where clauses
- quick selection of a random row from a large table in mysql
- Join tables with SUM issue in MYSQL
- Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
- Return default result for IN value regardless
- How can I search (case-insensitive) in a column using LIKE wildcard?
- Search for “whole word match” in MySQL
- sql joins as venn diagram
- How can I join multiple SQL tables using the IDs?
- MySQL, better to insert NULL or empty string?
- SQL: Repeat a result row multiple times, and number the rows
- SQL: selecting rows where column value changed from previous row
- Why do results from a SQL query not come back in the order I expect?
- How to generate data in MySQL?
- MySQL combine two columns and add into a new column
- Invalid default value for ‘dateAdded’
- How to skip certain database tables with mysqldump?
- MySQL error 1241: Operand should contain 1 column(s)
- How to set a MySQL row to READ-ONLY?
- Split a string and loop through values in MySQL stored procedure
- How to create dummy variable columns for thousands of categories in Google BigQuery?
- Mysql: Order by like?
- Most efficient way to store IP Address in MySQL [duplicate]
- Getting first day of the week in MySql using Week No
- MySql. How to use Self Join
- SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci