List tables in MySQL database

Rene Castro - Dataedo Team Rene Castro 2018-10-04

Table of Contents:


    The query below lists tables in current or provided databases .To list tables all user databases use this query.

    Query

    Current database

    select table_schema as database_name,
        table_name
    from information_schema.tables
    where table_type = 'BASE TABLE'
            and table_schema = database() 
    order by database_name, table_name;
    

    Specified database

    select table_schema as database_name,
        table_name
    from information_schema.tables
    where table_type = 'BASE TABLE'
            and table_schema = 'database_name' -- enter your database name here
    order by database_name, table_name;
    

    Columns

    • table_schema - database (schema) name
    • table_name - table name

    Rows

    • One row: represents one table in a database
    • Scope of rows: all tables in current/selected database
    • Ordered by: table name

    Sample results

    You could also get this

    Get this interactive HTML data dictionary in minutes with Dataedo.

    See live HTML data dictionary sample

    Try for free

    0
    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).
    Accept