Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: 3806: Table/view/trigger name 'table1' is ambiguous.
 
From:   Anomy Anom

<-- 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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023