What's the easiest way to drop a table in Alteryx?

[tristank]

I create a lot of tables in Alteryx but rarely have to drop them. When I do, what is the most efficient way? Thanks for any insight.

[Felipe_Ribeir0 · Accepted solution]

Hi @tristank 

I would not dare to say that this is the most efficient way, but it is surely an efficient enough way. You can use the dynamic input tool with a dummy select 1 statement just to make the tool run without errors, and then drop the table.

select top 1 * from database.schema.table;

drop table database.schema.table

[tristank]

@Felipe_Ribeir0 thanks for your response it is much appreciated. I will test this out!

[tristank]

@Felipe_Ribeir0 I got over my fears of messing with tables and found a nice solution: An input tool straight to an output tool. You input the datasource you want to drop, output that same table to the DB but put the drop table query in the Post SQL of the output tool. Worked like a charm :)