T-SQL Columns, Tables Alias

In SQL, we can alias columns, views and tables. A table alias is also called a co-relation name.

It is a temporarily names of columns or tables.

The Alias temporarily assigns another name to a column, or table at the time of a SELECT query and the assigning alias doesn’t rename the column or table name actually!

Basically, it make column, or table more readable to the programmers.

Syntax:

--USE OF TABLE ALIAS
SELECT TBL.Id, TBL.Name 
    FROM [dbo].[Tbl_Demo] AS TBL
WHERE TBL.Id in (1, 2, 3) 

--USE OF COLUMN ALIAS
SELECT TBL.Id AS UID, TBL.Name AS UNAME
    FROM [dbo].[Tbl_Demo] AS TBL
WHERE TBL.Id in (1, 2, 3) 

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print

Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link.. My Tech Blog - https://www.code-sample.com/ My Books - Book 1 and Book 2