---
schema_version: "1"
id: 84186ffa7af6c2640ad89271a536464d2b846c0257f3169d04be319da8c0ea2c
title: ARRAY_REMOVE
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/array-func/array-remove.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-remove.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: c42c968e4d9503b7509a4e744129209608eb9801832f97e5098dfa5b2bd1e13a
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `ARRAY_REMOVE`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Returns a new array with all instances of a specified element removed.

## Syntax

```sql
array_remove(<array>, <element>)
```

## Arguments

### Required

- `<array>`: The source array.
- `<element>`: The value to remove.

## Returns

Returns an array with all occurrences of the specified element removed.

## Considerations

- Removes all occurrences of the element, not just the first.
- If the element isn't found, the original array is returned unchanged.

## Examples

### Remove All Occurrences

Remove all instances of a value from an array.

```sql
SELECT array_remove(array[1, 2, 1, 3], 1) AS result;
```

Returns `array[2, 3]`, removing both occurrences of 1.

## Related Documentation

- [Array Data Type](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/array.md)