Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 19:35:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

In answer to both this and your previous question:

When you use unqualified object names, Teradata attempts to qualify the name using the DEFAULT DATABASE in effect for the session (as one would expect) AND also using any other database explicitly included in the SQL statement. As long as there is only a single match, the resolver assumes it figured out what you meant and the statement works. If there are multiple possibilities, the statement fails.

	<Prev	Next>		<<First	<Prev	Next>	Last>>