# Settings

Settings have server, database and statement scope. Choose the scope before the option name so the change has the intended lifetime.

| Scope    | Interface                               | Effect                                                    |
| -------- | --------------------------------------- | --------------------------------------------------------- |
| Server   | XML configuration                       | Startup listeners, credentials, diagnostics and ceilings. |
| Database | SET or documented PRAGMA/catalog writes | Persisted defaults and effective database behavior.       |
| Format   | Statement SETTINGS                      | Input/output options for one statement.                   |

Read system.settings for effective database values and read-only format defaults. Server-only XML options are documented separately and do not appear there.

## Reference

* [Format settings](https://coordinatordb.com/docs/reference/settings/formats)
* [Format avro](https://coordinatordb.com/docs/reference/settings/formats/format-avro)
* [Format binary](https://coordinatordb.com/docs/reference/settings/formats/format-binary)
* [Format csv](https://coordinatordb.com/docs/reference/settings/formats/format-csv)
* [Format custom](https://coordinatordb.com/docs/reference/settings/formats/format-custom)
* [Format regexp](https://coordinatordb.com/docs/reference/settings/formats/format-regexp)
* [Format schema](https://coordinatordb.com/docs/reference/settings/formats/format-schema)
* [Format template](https://coordinatordb.com/docs/reference/settings/formats/format-template)
* [Input format](https://coordinatordb.com/docs/reference/settings/formats/input-format)
* [Output format](https://coordinatordb.com/docs/reference/settings/formats/output-format)
* [Server settings](https://coordinatordb.com/docs/reference/settings/server-settings/settings)
* [Database settings](https://coordinatordb.com/docs/reference/settings/session-settings)
* [log_queries, log_queries_min_query_duration_ms](https://coordinatordb.com/docs/reference/settings/session-settings/log-queries)
* [max_execution_time](https://coordinatordb.com/docs/reference/settings/session-settings/max-execution)
* [max_memory_usage](https://coordinatordb.com/docs/reference/settings/session-settings/max-memory-usage)
* [max_result_rows, max_response_bytes](https://coordinatordb.com/docs/reference/settings/session-settings/max-result)
* [max_threads](https://coordinatordb.com/docs/reference/settings/session-settings/max-threads)
* [foreign_keys, recursive_triggers, user_version, application_id](https://coordinatordb.com/docs/reference/settings/session-settings/other)