Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 06 Aug 2007 @ 16:51:37 GMT


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


Subj:   Show table shows different database
 
From:   RICHARD GOMEZ

We are running across an issue that I haven't seen before, and am wondering if this is considered normal or not. WE recently archived some tables from our production machine, and restored them onto test. When you do a show table this is what we get:

     show view edwAcctngMDevAdmView.NCSMTPFinanceNumber;

     REPLACE VIEW EDWACCTNGprodADMVIEW.NCSMTPFinanceNumber
                   AS

                    SELECT
                    UnitFinanceNumber,
                    E_UnitFinanceNumber,
                    E_Financenumber,
                    E_UnitName,
                    E_AOName,
                    SMTPeMailAddress,
                    ADeMailDisplayName,
                    e_bacode,
                    e_badesc,
                    e_areacode,
                    e_financestatus
                   FROM EDWACCTNGprodVIEW.NCSMTPFinanceNumber;

Notice that the show table statement points to DB "edwAcctngMDevAdmView" while the DDL displayed is referencing DB "EDWACCTNGprodADMVIEW". It seems almost like it's a symbolic link. Is this normal behavior? It has caused some issues with granting permissions, but other than that it seems to be working fine.


Rich



     
  <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