It is used when the name of a column or table is used other than their original names, but the modified name is only temporary, Aliases are the temporary names given to the table or column for the purpose of a particular SQL query.
- Aliases are useful when table or column names are big or not very clear.
- These are preferred when there is more than one table included in a query.
- Aliases are created to make table or column names more clear.
- The renaming is just a temporary replacement and the table name does not change in the original database.
select firstname as [Name] from customer
select firstname as [First Name] from customer