> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-server.md).

# SHOW CREATE SERVER

{% tabs %}
{% tab title="Current" %}
**Syntax**

```sql
SHOW CREATE SERVER server_name
```

**Description**

Shows the [CREATE SERVER](/docs/server/reference/sql-statements/data-definition/create/create-server.md) statement that created the given server definition.

**Example**

```sql
SHOW CREATE SERVER srv1\G
*************************** 1. row ***************************
       Server: srv1
Create Server: CREATE SERVER `srv1` FOREIGN DATA WRAPPER mysql 
  OPTIONS (HOST '172.30.0.58', DATABASE 'db1', USER 'maxscale', PASSWORD 'password');
```

{% endtab %}

{% tab title="< 11.7" %}
The `SHOW CREATE SERVER` statement is not available.
{% endtab %}
{% endtabs %}

## See Also

* [CREATE SERVER](/docs/server/reference/sql-statements/data-definition/create/create-server.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}