## About

Rename or (renaming) is a relational operator that rename:

- a relation
- or an attribute of the relation

## Articles Related

## Syntax

<MATH> \LARGE \rho_{a/b} R </MATH> rename the attribute a from R to b

in SQL, the rename operator is called as

`select a as b from R`

## Example

Rename the 4 attributes {A, B, A, C} resulting from the cross product between R1 and R2 to {A_1, B, A_2, C} <MATH> \LARGE \rho_{A_1,B,A_2,C} \left( \pi_{A,B}R_1 \times \pi_{A,C}R_2 \right) </MATH> where:

- x is a cross product
- <math>\pi</math> is a projection
- and R1, R2 are relations