website logo
⌘K
🏠Homepage
👋Introduction
Key Concepts & Architecture
🚀Getting Started
👨‍💻SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
🚨Error Handling
🆚Differences Between Oxla vs. PostgreSQL
Docs powered by archbee 

SHOW TABLES statement

3min

Overview

Show statements allow you to obtain information about existing tables.

Example

Execute the following query to list all available tables:

SHOW TABLES query
|
SHOW TABLES;


This might produce an output with a list of all existing tables as shown below:

Output
|
+------------+
| name       |  
+------------+
| lineorder  |
| part       | 
| customer   | 
| supplier   | 
+------------+




Updated 11 May 2023
Did this page help you?
Yes
No
PREVIOUS
DROP statement
NEXT
DESCRIBE statement
Docs powered by archbee 
TABLE OF CONTENTS
Overview
Example

Dedicated to data analytics that provides 10x faster execution of analytical queries than current state of the art solutions. We are launching SOON! Join the waiting list for more info.




©2022 Oxla