## Purpose
A partition identifier with optional alias uniquely identifies one or more partitions from the currently available data containers.
The following partition codes have a special meaning:
- The value `default` specifies to use the partition(s) originally selected when you logged on to the platform providing the data container.
- The value `all` selects all partitions available on a data container.
## Partition Identifier with Alias
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '10' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
partitionIdentifierWithAlias_start((START))
partitionIdentifierWithAlias_start --> partitionIdentifierWithAlias_0_0[partitionIdentifier]
partitionIdentifierWithAlias_0_0 --> partitionIdentifierWithAlias_0_1[distributedAliasDirective]
partitionIdentifierWithAlias_0_1 --> partitionIdentifierWithAlias_end((END))
```
## Partition Identifier
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '10' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start((START)) --> partitionIdentifier
partitionIdentifier -->| | parameterExpression
parameterExpression --> End((END))
partitionIdentifier -->| | stringConstant
stringConstant --> End((END))
partitionIdentifier -->| | numericConstant
numericConstant --> End((END))
partitionIdentifier -->| | exprNode["<a href="Invantive UniversalSQL/General/Identifiers" class="internal-link">identifier</a>"]
exprNode["<a href="Invantive UniversalSQL/General/Identifiers" class="internal-link">identifier</a>"] --> End((END))
partitionIdentifier -->| | ALL["ALL"]:::quoted
ALL --> End((END))
partitionIdentifier -->| | DEFAULT["DEFAULT"]:::quoted
DEFAULT --> End((END))
```
## partitionSimpleIdentifier
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '10' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start((START)) --> partitionSimpleIdentifier
partitionSimpleIdentifier -->| | numericConstant
numericConstant --> End((END))
partitionSimpleIdentifier -->| | exprNode["<a href="Invantive UniversalSQL/General/Identifiers" class="internal-link">identifier</a>"]
exprNode["<a href="Invantive UniversalSQL/General/Identifiers" class="internal-link">identifier</a>"] --> End((END))
```
# Open Issues
- Kunnen we deze "partitionSimpleIdentifier" overal vervangen door "partitionIdentifier", of op zijn minst stringConstant toevoegen in g4?