showtables Back | Forward | Home

'Language Reference'

User Functions

Database Functions

Data Manipulation Functions

Table Functions
  • showtables

  • createtable

  • droptable

  • altertable

  • describe

  • table_count

  • empty_cache

  • table_exists

  • last_insert_id


  • Error Handling Functions

    << Last Section ( Table Functions ) showtables Next Section ( createtable ) >>
    Usage mixed showtables ( array (['db' => $db]) )
    Purpose To get a list of txtSQL tables inside a database
    Availability txtSQL >= 2.2.2 RC2

    This function returns a list of tables inside a txtSQL database. If no database is given, txtSQL will search the selected database.

    Important- To achieve the same results as this function before txtSQL 2.2.2 RC2, use the execute() function
    Note- If no $db is specified and no database is already selected, txtSQL will issue an error

    Example 20: showtables() Copy to Clipboard
    <?php
    $tables
    = $sql->showtables(array('db' => 'testDb'));

    print_r($tables);
    ?>

    User-Contributed Comments for:
    showtables()
    No comments found;