SQL - As clause

Data System Architecture

About

The as sql clause renames a relation or the attribute of a relation.

This is a runtime operation and does not rename a table or a column. To rename a table or a column, the alter statement should be used.

This equivalent operator in relational algebra is the rename operator

Example

select a as a1 from R as R1





Discover More
Relational Algebra Between Sql And Query Plan
Relational Operator - Rename

Rename or (renaming) is a relational operator that rename: a relation or an attribute of the relation rename the attribute a from R to b as Rename the 4 attributes {A, B, A, C} resulting...



Share this page:
Follow us:
Task Runner