Load all table/field names in directory

[#1]

Dear sirs,

I run Microsoft Dynamics and qlikview.

In my Dynamics database i have some 1000 tables and some 10000 fields, and i would like to have a better overview over the lot.

Is there anyway you gents can teach me how to write a generic script that loads all table names and field names in my directory into a qlikview? I just need a complete overview over which table names and field names my databsae contains.

When i load from my Dynamics database the script line is like this:

EventResponsible:

LOAD
*;
SQL SELECT * FROM AX2009Prod.dbo.VCCEVENTRESPONSIBLE;

[martinpohl · Accepted solution]

Hello,

try sqltables or sqlcolumns (see manual)

Regards

[#3]

The perfect answer. Many thanks.