Archives of the TeradataForum

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

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

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>>