Reference Name (reference_name)

The reference name (reference_name) is an identifier that is declared for a certain validity range and associated with exactly one table. The scope of this declaration is the entire SQL statement.

Structure

Syntax Syntax

```
<reference_name> ::=
  <identifier>
```

End of the code.

The identifier may not exceed 32 characters in length.

Explanation

A reference name specified in various validity ranges can be associated with different tables or with the same table.

More Information

Column Specification

Selected Column

Table Expression

Recursive DECLARE CURSOR statement

UPDATE Statement

DELETE Statement