Home    Back    Forward    Refresh    txtSQL Homepage
txtSQL Documentation > SQL Syntax > SHOW TABLES Syntax

SHOW TABLES Syntax
txtSQL >= 3.0.0 Beta

SHOW TABLES [ IN ( table | db.table ) ]

This function will return an array populated with all the tables, either in the selected database or the specified database.

NOTE- To have a complete look at the SHOW TABLES function, and any changes to its functionality, see the showtables() function


User Comments - SHOW TABLES Syntax
No comments posted yet;
Last Page Next Page

'Language Reference'

User Functions

Database Functions

Data Manipulation Functions

Table Functions

Error Handling Functions

SQL Syntax
  • SELECT Syntax
  • INSERT Syntax
  • DELETE syntax
  • UPDATE Syntax
  • CREATE DATABASE Syntax
  • DROP DATABASE Syntax
  • SHOW DATABASES Syntax
  • USE Syntax
  • LOCK Syntax
  • UNLOCK Syntax
  • IS LOCKED Syntax
  • CREATE TABLE Syntax
  • DROP TABLE Syntax
  • SHOW TABLES Syntax
  • DESCRIBE Syntax
  • SHOW USERS Syntax
  • GRANT PERMISSIONS Syntax
  • Column Properties
  • Column Types
  • LIMIT Syntax
  • ORDERBY Syntax
  • WHERE Syntax

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