With SQL, aliases can be used for column names and table names.

Column Name Alias

The syntax is:

SELECT column AS column_alias FROM table

Table Name Alias

The syntax is:

SELECT column FROM table AS table_alias

Example: Using a Column Alias

This table (Persons):

And this SQL:

SELECT LastName AS Family, FirstName AS Name
FROM Persons

Returns this result:

Example: Using a Table Alias

This table (Persons):

And this SQL:

SELECT LastName, FirstName
FROM Persons AS Employees

Returns this result:

Table Employees: