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

# SET

> Use the `SET` command to change a runtime parameter.

## Syntax

```sql theme={null}
SET parameter_name { TO | = } { value | 'value' | DEFAULT};
```

## Parameters

| Parameter or clause | Description                                                                                                                                                                                                                                                                                                                                               |
| :------------------ | :-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *parameter\_name*   | Name of the runtime parameters.                                                                                                                                                                                                                                                                                                                           |
| *value*             | New value of parameter. Values can be specified as string constants, identifiers, numbers, or comma-separated lists of these, as appropriate for the particular parameter. DEFAULT can be written to specify resetting the parameter to its default value (that is, whatever value it would have had if no SET had been executed in the current session). |

## Special case

In addition to standard parameter settings, RisingWave supports switching databases during an active session using either `SET DATABASE TO` or `USE`. Both commands allow you to change the current database without disconnecting and reconnecting.

```sql Example theme={null}
-- Switch database using SET DATABASE TO 
SET DATABASE TO sales_db;

-- Switch database using USE
USE marketing_db;
```