Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.oxla.com/llms.txt

Use this file to discover all available pages before exploring further.

​
Overview

The SHOW TABLES statement allows you to obtain information about existing tables.
It only shows tables in schemas, on which a user has the USAGE grant

​
Example

So as to list all available tables, you need to execute the following query: 
SHOW TABLES;
This will produce an output with a list of all existing tables, an example of which is presented below: 
+------------+
| name       |  
+------------+
| lineorder  |
| part       | 
| customer   | 
| supplier   | 
+------------+