Archives of the TeradataForum

Message Posted: Tue, 17 Dec 2003 @ 01:09:32 GMT

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

Think of the default database as one entry in a search list of databases not as a text substitution for a missing database specifier. All other databases named explicitly in the request are also added to the search list. Then each object is looked up in the databases in the search list. An object that appears in multiple databases in the search list is ambiguous.

I think your cases will make more sense evaluated this way. This is a purposeful "ease of use feature" (except when it confuses people :- ).

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