topic API QUESTION DROP TABLE in QlikView

API QUESTION DROP TABLE

Mon, 26 Jan 2026 18:19:17 GMT

Dear all,

I have a qvw file only for reload and execute macros.

After execute all I want to drop all tables.

I have that sub but i don't know how ho drop tables:

Sub Droptables

set doc=ActiveDocument

for i=0 to doc.GetTableCount-1

name = doc.GetTableName(i)

'doc.deletetable(name)

end sub

API QUESTION DROP TABLE

prieper — Fri, 04 Mar 2011 10:09:20 GMT

Why don't you do it in the script:

DROP TABLE YourTable;
or
DROP TABLES YourTable1, YourTable2;

HTH
Peter

API QUESTION DROP TABLE

stephencredmond — Fri, 04 Mar 2011 10:10:14 GMT

Hi,

Not sure you can do this via the API. However, what is stopping you doing it at the end of your script?

Regards,

Stephen

API QUESTION DROP TABLE

Wed, 09 Mar 2011 15:58:18 GMT

Dear,

after reload, I'm executing a Macro that is doing some export.

After that, I want to clear all the data and save the file.

File is loading from another QVW and it's near 2 Gigs, and I don't want to have all the data on the file because it's reloading every day and i don't need the data.

Best regards.

API QUESTION DROP TABLE

llauses243 — Wed, 09 Mar 2011 20:49:14 GMT

Hi Jordi ,

If drop all tables the document (.qvw) useful zero only schema

Left macro for clear data & save document , to apply OnClose

Good luck, from Spain, Luis (0034657486722)

API QUESTION DROP TABLE

Thu, 10 Mar 2011 09:00:26 GMT

Dear Luis,

thanks for your answer but How I can execute macro OnClose (I don't have that option to select on document propierties)

Saludos desde Barcelona.