Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 30 Sep 2011 @ 11:30:17 GMT

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

Subj:   Re: How to Fetch tables from Database with different suffixes
From:   Mankala, Mahesh


Please try this below one.

     select substring((trim(tablename)) from character(trim(tablename))-3 for 4)
     from dbc.tables
     where upper ((substring((trim(tablename)) from character(trim(tablename))-3 for 4)))
              = lower((substring((trim(tablename)) from character(trim(tablename))-3 for 4))) (casespecific)
       and databasename='XXXX'


Mahesh Mankala

  <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