SHOW TABLES statement

3min

OverviewShow statements allow you to obtain information about existing tables.
ExampleExecute the following query to list all available tables:
SHOW TABLES query
|
SHOW TABLES;
SHOW TABLES;
﻿
This might produce an output with a list of all existing tables as shown below:
Output
|
+------------+
| name       |  
+------------+
| lineorder  |
| part       | 
| customer   | 
| supplier   | 
+------------+
+------------+
| name       |  
+------------+
| lineorder  |
| part       | 
| customer   | 
| supplier   | 
+------------+
﻿
﻿

Updated 11 May 2023

Did this page help you?

Yes

DROP statement

DESCRIBE statement

Docs powered by archbee

TABLE OF CONTENTS

Overview

Example