# SHOW TABLES

[Read this page in HTML](https://www.scopedb.io/docs/reference/commands/statements/show-tables)

Lists the tables and views you can access.

## Syntax

```scopeql
SHOW [ FULL ] TABLES [ IN <schema_name> ]
```

## Parameters

### `FULL`

Includes partitioning, deduplication, row counts, and storage statistics in addition to names, types, and comments. Statistics may be NULL when unavailable.

### `<schema_name>`

Optional schema to list. If omitted, lists tables across all schemas you can access.

## Examples

List tables in the `public` schema:

```scopeql
SHOW TABLES IN public
```