> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ditto.live/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW

> The SHOW statement displays the values of configuration parameters in your Ditto environment.

The `SHOW` statement allows you to view configuration parameter values that control various aspects of your Ditto instance's behavior.

## Syntax

```sql DQL theme={null}
SHOW ALL [LIKE pattern | ILIKE pattern [ESCAPE char]]
SHOW parameter_name
```

<img src="https://mintcdn.com/ditto-248bc0d1/pf3IlRElveI85RoM/images/dql/Show.svg?fit=max&auto=format&n=pf3IlRElveI85RoM&q=85&s=769c9035b49a7f2c9a2f221d743e3872" alt="SHOW Syntax Diagram" width="673" height="197" data-path="images/dql/Show.svg" />

## SHOW ALL

Display all configuration parameters and their current values:

```sql DQL theme={null}
SHOW ALL
```

### Filtering with LIKE

You can filter the parameters displayed using pattern matching:

```sql DQL theme={null}
-- Show all parameters containing "query"
SHOW ALL LIKE '%query%'

-- Show all parameters starting with "dql"
SHOW ALL LIKE 'dql%'

-- Case-insensitive pattern matching
SHOW ALL ILIKE 'DQL%'
```

The pattern supports:

* `%` - Matches zero or more characters
* `_` - Matches exactly one character

### Escape Characters

If you need to match literal `%` or `_` characters in parameter names, use the `ESCAPE` clause:

```sql DQL theme={null}
SHOW ALL LIKE 'param\_%' ESCAPE '\'
```

## SHOW Specific Parameter

Display the value of a single configuration parameter:

```sql DQL theme={null}
SHOW dql_strict_mode
```

## Common Configuration Parameters

Some frequently used configuration parameters include:

| **Parameter**     | **Description**                                              |
| ----------------- | ------------------------------------------------------------ |
| `dql_strict_mode` | Controls whether strict mode is enabled for type definitions |
| `max_query_time`  | Maximum execution time for queries                           |

<Note>
  Use `SHOW ALL` to see the complete list of available configuration parameters and their current values in your Ditto instance.
</Note>

## Usage Examples

<CodeGroup>
  ```swift Swift theme={null}
  // Show all parameters
  let result = await ditto.store.execute(
    query: "SHOW ALL"
  )

  // Show specific parameter
  let strictMode = await ditto.store.execute(
    query: "SHOW dql_strict_mode"
  )

  // Show parameters matching pattern
  let dqlParams = await ditto.store.execute(
    query: "SHOW ALL LIKE 'dql%'"
  )
  ```

  ```kotlin Kotlin theme={null}
  // Show all parameters
  val result = ditto.store.execute("SHOW ALL")

  // Show specific parameter
  val strictMode = ditto.store.execute("SHOW dql_strict_mode")

  // Show parameters matching pattern
  val dqlParams = ditto.store.execute("SHOW ALL LIKE 'dql%'")
  ```

  ```javascript JS theme={null}
  // Show all parameters
  const result = await ditto.store.execute("SHOW ALL");

  // Show specific parameter
  const strictMode = await ditto.store.execute("SHOW dql_strict_mode");

  // Show parameters matching pattern
  const dqlParams = await ditto.store.execute("SHOW ALL LIKE 'dql%'");
  ```

  ```java Java theme={null}
  // Show all parameters
  var result = ditto.store.execute("SHOW ALL");

  // Show specific parameter
  var strictMode = ditto.store.execute("SHOW dql_strict_mode");

  // Show parameters matching pattern
  var dqlParams = ditto.store.execute("SHOW ALL LIKE 'dql%'");
  ```

  ```csharp C# theme={null}
  // Show all parameters
  var result = await ditto.Store.ExecuteAsync("SHOW ALL");

  // Show specific parameter
  var strictMode = await ditto.Store.ExecuteAsync("SHOW dql_strict_mode");

  // Show parameters matching pattern
  var dqlParams = await ditto.Store.ExecuteAsync("SHOW ALL LIKE 'dql%'");
  ```

  ```cpp C++ theme={null}
  // Show all parameters
  auto result = ditto.get_store().execute("SHOW ALL").get();

  // Show specific parameter
  auto strictMode = ditto.get_store().execute("SHOW dql_strict_mode").get();

  // Show parameters matching pattern
  auto dqlParams = ditto.get_store().execute("SHOW ALL LIKE 'dql%'").get();
  ```

  ```rust Rust theme={null}
  // Show all parameters
  let result = ditto.store()
      .execute_v2(("SHOW ALL", serde_json::json!({})))
      .await?;

  // Show specific parameter
  let strict_mode = ditto.store()
      .execute_v2(("SHOW dql_strict_mode", serde_json::json!({})))
      .await?;

  // Show parameters matching pattern
  let dql_params = ditto.store()
      .execute_v2(("SHOW ALL LIKE 'dql%'", serde_json::json!({})))
      .await?;
  ```

  ```dart Dart theme={null}
  // Show all parameters
  final result = await ditto.store.execute("SHOW ALL");

  // Show specific parameter
  final strictMode = await ditto.store.execute("SHOW dql_strict_mode");

  // Show parameters matching pattern
  final dqlParams = await ditto.store.execute("SHOW ALL LIKE 'dql%'");
  ```
</CodeGroup>

## See Also

* [ALTER SYSTEM](/dql/alter-system) - Modify configuration parameters at runtime
* [Strict Mode](/dql/strict-mode) - Understanding DQL\_STRICT\_MODE parameter