List of Tables

[#1]

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

[flipside · Accepted solution]

Try this ...

Table1:

Load *;
SQLTABLES;

qualify *;
Table2:
Load * resident Table1 where TABLE_TYPE='TABLE';
unqualify *;

drop table Table1;