Referencing Object Names in a Request | SQL Fundamentals | Teradata Vantage - 17.10 - Referencing Object Names in a Request - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Fundamentals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1141-171K
Language
English (United States)

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 Information

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