Home    Back    Forward    Refresh    txtSQL Homepage

showtables
Purpose: To get a list of txtSQL tables inside a database
txtSQL >= 2.2.2 RC2
mixed showtables ( array (['db' => $db]) )

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 Comments - showtables
No comments posted yet;
Last Page Next Page

'Language Reference'

User Functions

Database Functions

Data Manipulation Functions

Table Functions
  • showtables
  • createtable
  • droptable
  • altertable
  • describe
  • table_count
  • emptyCache
  • table_exists
  • last_insert_id

    Error Handling Functions

    SQL Syntax

  • [ txtSQL Documentation powered by txtSQL | 6 SQL Queries ]