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

# SHOW SYSTEM PROPERTIES

<a id="show-system-properties" />

<a id="sql-show-system-properties" />

System properties can be shown by any user.

```sql title="SHOW SYSTEM PROPERTIES Syntax" theme={null}
SHOW SYSTEM PROPERTIES
[WITH OPTIONS ('properties' = '<config parameter name>[,...]')]
```

## Examples

To show all system properties:

```sql SHOW SYSTEM PROPERTIES Example theme={null}
SHOW SYSTEM PROPERTIES
```

To show the internal & external cluster node URLs:

```sql SHOW SYSTEM PROPERTIES Individually Example theme={null}
SHOW SYSTEM PROPERTIES
WITH OPTIONS ('properties' = 'conf.worker_http_server_urls,conf.worker_http_server_urls_private')
```

To show all [RAM tier](/content/rm/concepts#rm-concepts-tiers-ram) properties:

```sql SHOW RAM Tier Properties Example theme={null}
SHOW SYSTEM PROPERTIES
WITH OPTIONS
(
    'properties' =
    '
        conf.tier.ram.default.high_watermark,
        conf.tier.ram.default.limit,
        conf.tier.ram.default.low_watermark,
        conf.tier.ram.rank0.high_watermark,
        conf.tier.ram.rank0.limit,
        conf.tier.ram.rank0.low_watermark,
        conf.tier.ram.rank1.high_watermark,
        conf.tier.ram.rank1.limit,
        conf.tier.ram.rank1.low_watermark,
        conf.tier.ram.rank2.high_watermark,
        conf.tier.ram.rank2.limit,
        conf.tier.ram.rank2.low_watermark
    '
)
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.