16.10 - Referencing All Columns in a Table - Teradata Database

Teradata Database SQL Fundamentals

Product
Teradata Database
Release Number
16.10
Published
June 2017
Content Type
Programming Reference
Publication ID
B035-1141-161K
Language
English (United States)
Last Update
2018-04-25

An asterisk references all columns in a row simultaneously, for example, the following SELECT statement references all columns in the Employee table. A list of those fully qualified column names follows the query.

   SELECT * FROM Employee;
   Personnel.Employee.EmpNo
   Personnel.Employee.Name
   Personnel.Employee.DeptNo
   Personnel.Employee.JobTitle
   Personnel.Employee.Salary
   Personnel.Employee.YrsExp
   Personnel.Employee.DOB
   Personnel.Employee.Sex
   Personnel.Employee.Race
   Personnel.Employee.MStat
   Personnel.Employee.EdLev
   Personnel.Employee.HCap