# correlationName

A correlationName is given to a table expression in a FROM clause as a new name or alias for that table. You cannot qualify a correlationName with a schemaName.

You cannot use correlationNames for updatable columns; using correlationNames in this way will cause an SQL exception. For example:

    SELECT c11 AS col1, c12 AS col2, c13 FROM t1 FOR UPDATE of c11,c13

In this example, the correlationName `col1 FOR c11` is not permitted because `c11` is listed in the FOR UPDATE list of columns. You can use the correlationName `FOR c12` because it is not in the FOR UPDATE list.

## Syntax

    SQLIdentifier

## Example

    -- C is a correlationName
    SELECT C.NAME
    FROM SAMP.STAFF C

Parent topic: SQL identifiers