Alias

noun

say it: “AY-lee-us” /ˈeɪliəs/

A short name given to a table in a query, such as o for Orders, so columns can be written o.OrderID.

What is an Alias?

An Alias is an alternate (usually short) name assigned to a table to make it easier to differentiate between tables. This is commonly done when joining 2 or more tables.

SELECT c.CustomerName
    , o.OrderDate
    , o.OrderId
FROM Customers AS c
INNER JOIN Orders AS o
    ON c.CustomerId = o.CustomerId

In a sentence

  • “With the alias c for Customers, the join reads c.CompanyName.”

Level: Journeyman · More SQL terms at this level

Updated

In other subjects