 statements allow you to obtain information about existing tables.

Execute the following query to list all available tables:

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

The SHOW TABLES statement is used to retrieve the data of a specified table. Let's quickly cover the overview and an example of the SHOW TABLES statement.

DROP statement

SHOW TABLES statement

DESCRIBE statement

Oxla Developer Hub

Homepage

OLTP vs OLAP

Oxla vs. Other OLAP Solutions

Our Key Features

Key Concepts & Architecture

Introduction

Run Oxla on S3

Multi-node Deployment

Run Oxla in 2 minutes

SQL TABLE

CREATE TABLE statement

CREATE INDEX statement

SELECT statement

SHOW NODES statement

COPY FROM statement

SQL Queries

FROM

WHERE

GROUP BY

HAVING

ORDER BY

LIMIT

OFFSET

Set Operations

SQL Clauses

Data Type Operators

Bool Type

Date Type

Timestamp Without Time Zone Type

Timestamp with Time Zone

Time Type

Interval Type

Text Type

Numeric Type

JSON Type

SQL Data Types

Numeric Functions

Aggregation Functions

String Functions

Timestamp Functions

Boolean Function

JSON Functions

Other Functions

Trigonometric Functions

SQL Functions

Schema

Comment Support

SQL Reference

DELETE

UPDATE

SQL Mutations

Error Handling

Differences Between Oxla vs. PostgreSQL

Understanding Transactions

Public Metrics

Oxla Configuration File

Changelog

SHOW TABLES statement

Overview

Example