# SHOW OBJECTS
`SHOW OBJECTS` returns a list of all objects in Materialize for a given schema.

> For the complete documentation index, see [llms.txt](https://preview.materialize.com/materialize/40269/llms.txt).


`SHOW OBJECTS` returns a list of all objects in Materialize for a given schema.
Objects include tables, sources, sinks, views, materialized views, indexes,
secrets and connections.

## Syntax

```mzsql
SHOW OBJECTS [ FROM <schema_name> ];
```

Syntax element               | Description
-----------------------------|------------
**FROM** <schema_name>       | If specified, only show objects from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see [`SHOW SCHEMAS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-schemas/index.md).

## Details

### Output format

`SHOW OBJECTS` will output a table with two columns, `name`and `type`.

## Examples

```mzsql
SHOW SCHEMAS;
```
```nofmt
  name
--------
 public
```
```mzsql
SHOW OBJECTS FROM public;
```
```nofmt
  name          | type
----------------+-------
my_table        | table
my_source       | source
my_view         | view
my_other_source | source
```
```mzsql
SHOW OBJECTS;
```
```nofmt
  name    | type
----------+-------
my_table  | table
my_source | source
my_view   | view
```

## Related pages

- [`SHOW TABLES`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-tables/index.md)
- [`SHOW SOURCES`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-sources/index.md)
- [`SHOW SINKS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-sinks/index.md)
- [`SHOW VIEWS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-views/index.md)
- [`SHOW INDEXES`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-indexes/index.md)
- [`SHOW SECRETS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-secrets/index.md)
- [`SHOW CONNECTIONS`](https://preview.materialize.com/materialize/40269/markdown-docs/sql/show-connections/index.md)