> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# SHOW LOCALITY
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `SHOW LOCALITY` statement returns the locality of the current node.
If locality was not specified on node startup, the statement returns an empty row.
## Required privileges
No privileges are required to list the locality of the current node.
## Synopsis
## Example
### Setup
The following example uses MovR, a fictional vehicle-sharing application, to demonstrate CockroachDB SQL statements. For more information about the MovR example application and dataset, see MovR: A Global Vehicle-sharing App.
To follow along, run `cockroach demo movr` with the `--nodes` and `--demo-locality` tags. This command opens an interactive SQL shell to a temporary, multi-node in-memory cluster with the `movr` database preloaded and set as the current database.
```shell theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
$ cockroach demo movr --nodes=3 --demo-locality=region=us-east,az=a:region=us-central,az=b:region=us-west1,az=c
```
### Show locality
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW LOCALITY;
```
```
locality
+---------------------+
region=us-east,az=a
(1 row)
```
### Show locality with a built-in function
If you know the locality key, you can use the `crdb_internal.locality_value` built-in function to return the locality value for the current node:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM crdb_internal.locality_value('region');
```
```
crdb_internal.locality_value
+------------------------------+
us-east
(1 row)
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM crdb_internal.locality_value('az');
```
```
crdb_internal.locality_value
+------------------------------+
a
(1 row)
```
For a more extensive example, see Create a table with node locality information.
## See also
* Locality
* Orchestrated Deployment
* Manual Deployment