Delete a Postgres Table Using Alteryx Designer

[NeilFisk]

I created a workflow that creates a table in a Postgres database.  I want to know how to delete the same table.  How is this done?

[fmvizcaino]

Hey @NeilFisk ,

You can use the pre or post sql statement in the output data tool.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Pre-Post-SQL-Statements/ta-...

Another option is to include the query in the input data tool along side everything else you have there.

Best,

Fernando Vizcaino