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

    List of Tables



      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:



      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