A single item in a SELECT list
Format
{ [ [ Schema . ] Table . ] * | expression [ AS Alias ] }
Remarks
Specifies a single item in a select list.
The first form: Table.* adds all columns in the table to the select list.
The second form: expression [ AS Alias ] adds an expression with optional column alias to the select list.