SQL Aliases

SQL Aliases are the temporary names given to table or column for the purpose of a particular SQL query. It is used when name of column or table is used other than their original names, but the modified name is only temporary.

• • • Aliases are created to make table or column names more readable.
    • The renaming is just a temporary change and table name does not change in the original database.
    • Aliases are useful when table or column names are big or not very readable.
    • These are preferred when there are more than one table involved in a query.

    Basic Syntax:
    For column alias:
    

    SELECT column as alias_name FROM table_name;

    column: fields in the table
    alias_name: temporary alias name to be used in replacement of original column name
    table_name: name of table
    For table alias:
    SELECT column FROM table_name as alias_name;
    column: fields in the table
    table_name: name of table
    alias_name: temporary alias name to be used in replacement of original table name