Aliases in sql server

SQL server aliases are used to temporarily rename a table or a column heading.

SQL Aliases

SQL aliases are used to give a database table, or a column in a table, a temporary name.

Basically aliases are created to make column names more readable.

Alias Syntax for Columns

SELECT column_name AS alias_name
FROM table_name;

Alias Syntax for Tables

SELECT column_name(s)
FROM table_name AS alias_name;