Delete tables (QVD)

[#1]

Hi all,

I'm creating a table with 'store into' in order to make a later load and concatenate.

how can I, from the script, delete this table when I complete the concatenation?

Thanks,

Boris

[Anonymous]

drop table YourTable ;

[tresesco · Accepted solution]

Try like:

EXECUTE CMD.EXE /C del "yourqvd.qvd";

[#4]

I'm not talking about in memory table, it an already created QVD

[edwinmatlapeng]

drop table 'tablename' should work! this will delete both a memory table and an existing QVD!

[#6]

Sorry, but it doesn't work.

QV documentation states that drop table is for in memory tables.

Also, I tried a test and it didn't delete the table.

thank you anyway.