“A bird does not sing because it has the answers, it sings because it has a song.”
Teradata Assigns each Object a Unique Numeric ID
Your SQL uses database names, table names and column names, but each of these is actually given a numeric ID and it is that Numeric ID that the Parsing Engine (PE) and the Access Module Processors (AMPs) use to track the objects.
Each Database, User, Profile and Role is assigned a globally unique numeric ID.
Each Table, View, Macro, Trigger, Stored Procedure, User-defined Function, Join Index, and Hash Index is assigned their own globally unique numeric ID.
Each Column is assigned a numeric ID that is unique within its Table ID.
Each Index is assigned a numeric ...