# SHOW CREATE LINK

Shows the `CREATE LINK` command used to create a link.

## Syntax

```sql
SHOW CREATE LINK <link_name>
```

## Argument

`link_name`: Name of the link.

## Remarks

* The `SHOW CREATE LINK` command does not support links to the `HTTP` sources (`CREATE LINK ... AS HTTP`).
* Password and other sensitive information is masked in the `SHOW CREATE LINK` output.
* Refer to [Permissions Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the permissions required to run this command.

## Example

The following example shows that sensitive information is hidden from the output:

```sql
CREATE LINK pLink AS MYSQL 
CONFIG '{
  "database.hostname": "svchost", 
  "database.exclude.list": "dbTest", 
  "database.port": 3306, 
  "database.ssl.mode":"required"}' 
CREDENTIALS '{
  "database.password": "pa55w0rd", 
  "database.user": "s2user"}';

SHOW CREATE LINK pLink \G

```

```output

  Link Name: pLink
Create Link: CREATE LINK `pLink` AS MYSQL 
CONFIG "{\n  \"database.hostname\": \"svchost\", \n  
\"database.exclude.list\": \"dbTest\", \n  
\"database.port\": 3306, \n  
\"database.ssl.mode\":\"required\"}" 
CREDENTIALS <CREDENTIALS REDACTED>
```

The output is formatted for readability.

***

Modified at: June 5, 2025

Source: [/db/v9.1/reference/sql-reference/show-commands/show-create-link/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-create-link/)

(An index of the documentation is available at /llms.txt)