Content deleted Content added
link sql template |
No edit summary |
||
Line 1:
{{unref|date=December 2012}}
An alias (Correlation Name<ref>ANSI Standard SQL - Foundation Document - Date: 2010-10-14</ref>) 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.
In SQL, you can alias both tables themselves or the [[Column (database)|columns]]. A programmer can temporarily assign another name to a table or column (for the duration of the [[Select (SQL)|SELECT query]]) by using an alias. In other words, it does not actually rename the column or table. This is often useful when either tables or their columns have very long or complex names. An alias name could be anything, but usually it is kept short. For example, it might be common to use a table alias such as "pi" for a table named "price_information".
Line 49:
[[Category:SQL]]
==References==
{{Reflist}}
| |||