10 Replies Latest reply: Nov 3, 2015 8:04 AM by Dave Riley RSS

    List of Tables

    Christian Wylezol

      Hi,

       

      maybe someone of you can help me.

      We have a database where I take Datas from.

      We take this datafields out of tables from the database.

       

      Now my question:

      I dont Need datas from a table but a list of all tables within the database.

      How can I realise that?

       

      Our IT-Guy wrote to me the following, but unfortunately qlikview cannot handle this:

       

      select

      substr(segment_name,1,30) segment,

      substr(segment_type,1,10) typ,

      bytes/1024/1024 MB

      from dba_segments

      where segment_type = ‘TABLE’

       

       

       

      Thanks in advance

      Chris