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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/array/array-reverse",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for ARRAY_REVERSE function

# ARRAY_REVERSE

Returns an array of the same size and type as the original array, with the elements in reverse order. Nulls are retained.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
ARRAY_REVERSE(<array>)
```

## Parameters

| Parameter | Description              | Supported input types |
| :-------- | :----------------------- | :-------------------- |
| `<array>` | The array to be reversed | `ARRAY` of any type   |

## Return Type

`ARRAY` of the same type as the input array

## Example

The following example returns the reverse of the input array:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_REVERSE([ 1, 2, 3, 6 ]);
```

**Returns**: `[6,3,2,1]`

Only the outermost array is reversed for nested arrays:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
	ARRAY_REVERSE([[1,2,3], [4,5], NULL, [7], [8,9]]);
```

**Returns**: `[[8,9], [7], NULL, [4,5], [1,2,3]]`