16.20 - Referencing Object Names in a Request - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageâ„¢ SQL Fundamentals

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
zce1519094756513.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

When you reference an object name in a request, you may need to qualify the name. The topics that follow explain the rules for use of qualified and unqualified object names.

The following example shows unqualified, qualified and a fully qualified name references in a SELECT statement that accesses the Employee table in the personnel database:

SELECT Name, DeptNo, JobTitle
FROM Personnel.Employee
WHERE Personnel.Employee.DeptNo = 100 ;

Related Topics

For more information about the default database, see The Default Database.