Website logo
⌘K
🏠Homepage
👋Introduction
Key Concepts & Architecture
🚀Run Oxla in 2 minutes
🏃‍♂️Run Oxla on S3
🛫Multi-node Deployment
👨‍💻SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
Comment Support
⛓️SQL Mutations
DELETE
UPDATE
🚨Error Handling
🆚Differences Between Oxla vs. PostgreSQL
🔄Understanding Transactions
📈Public Metrics
⚙️Oxla Configuration File
✨Changelog
Docs powered by Archbee
SQL Reference
SQL Queries

SHOW TABLES statement

2min

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 09 Oct 2023
Did this page help you?
PREVIOUS
DROP statement
NEXT
DESCRIBE statement
Docs powered by Archbee
TABLE OF CONTENTS
Overview
Example
Docs powered by Archbee

©2023 Oxla