Alias (SQL): Difference between revisions

Revision as of 18:32, 26 December 2012

Revision as of 20:30, 8 March 2013

Line 1:

{{unref|date=December 2012}}

An alias is a feature of SQL that is supported by most, if not all, [[RDBMS|relational database management systems (RDBMSs)]]. Aliases provide [[database administrator]]s, as well as other database users, with the ability to reduce the amount of code required for a query, and to make queries generally simpler to understand. In addition, aliasing can be used as an [[Obfuscation_(software)|obfuscation technique]] to protect the real names of database fields.

<br />

Aliases provide [[database administrator]]s, as well as other database users, with two things:

# Reduces the amount of code required for a query, and

# To make queries generally simpler to follow.

There are two types of aliases in SQL: