How can I drop and create a table when writing to a database ?
I have a workflow which creates a table on an Oracle SQL Server. When the workflow is re-run, I want to be able to replace the table, if it already exists. The table does not have a key as it is a table of duplicates entries, so I cannot use the Delete or Update function.
I have tried to enter "drop table tablename;" in the pre SQL section of the export settings but this doesn't seem to work.