# organizations

## Description

Exposes basic metadata about the current organization. Each user sees only the organizations they are a member of. The `messages` field contains a JSON array of informational or warning messages issued by DeltaStream (e.g. billing or trial notices).

{% hint style="info" %}
**Note** This table returns one row per organization the current user is a member of.
{% endhint %}

## Syntax

```sql
SELECT ... FROM deltastream.sys."organizations";
```

## Columns

| Column     | Type    | Nullable | Description                                                                            |
| ---------- | ------- | -------- | -------------------------------------------------------------------------------------- |
| `id`       | VARCHAR | No       | Unique identifier of the organization.                                                 |
| `name`     | VARCHAR | No       | Name of the organization.                                                              |
| `messages` | VARCHAR | No       | JSON array of system messages associated with the organization (e.g. billing notices). |

## Examples

```sql
SELECT * FROM deltastream.sys."organizations";
```

```sh
[{"id":"00000000-0000-0000-0000-000000000001","name":"asdf","messages":"[]"}]
```

## See Also

* [System Tables Overview](https://docs.deltastream.io/reference/sql-syntax/systables)
* [LIST ORGANIZATIONS](https://docs.deltastream.io/reference/sql-syntax/command/list-organizations)