Archives of the TeradataForum

Message Posted: Tue, 19 Dec 2006 @ 17:02:20 GMT

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

<-- Anonymously Posted: Tuesday, December 19, 2006 11:54 -->

SQL Reference - Fundamentals:
Chapter 2: Basic SQL Syntax and Lexicon
Unqualified Object Names

When you omit the database name qualifier, Teradata Database looks in the following databases to find the unqualified table, view, trigger, or macro name:

* The default database, which is established by a DATABASE, CREATE USER, MODIFY USER, CREATE PROFILE, or MODIFY PROFILE statement

* Other databases, if any, referenced by the SQL statement

* The login user database for a volatile table, if the unqualified object name is a table name

The search must find the table name in only one of those databases. An ambiguous name error message results if the name exists in more than one of those databases.

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