Guides
List Tables
The `SHOW TABLES` command can be used to obtain a list of all tables within the selected schema.  
```sql
CREATE TABLE tbl (i INTEGER);
SHOW TABLES;
```  
<div class="narrow_table"></div>  
| name |
|------|
| tbl  |  
`SHOW` or `SHOW ALL TABLES` can be used to obtain a list of all tables within **all** attached databases and schemas.  
```sql
CREATE TABLE tbl (i INTEGER);
CREATE SCHEMA s1;
CREATE TABLE s1.tbl (v VARCHAR);
SHOW ALL TABLES;
```  
<div class="narrow_table"></div>  
| database | schema | table_name | column_names | column_types | temporary |
|----------|--------|------------|--------------|--------------|-----------|
| memory   | main   | tbl        | [i]          | [INTEGER]    | false     |
| memory   | s1     | tbl        | [v]          | [VARCHAR]    | false     |  
To view the schema of an individual table, use the [`DESCRIBE` command](#docs:guides:meta:describe).