We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Deleting Tables in the Database

xariet
8 - Asteroid

Hi All,

What are the ways to drop a table in the database using Alteryx? Write Data in DB tool and normal output tool only have an option Delete Data & Append or Overwrite table(drop).

When I use Connect in DB tool for deleting the table using sql statement select * from "people";
drop table "people";  the table is not deleted from the database.

 

1 REPLY 1
xariet
8 - Asteroid

I have just figured out how to do that in case somebody will find this useful

 

xariet_0-1668561012560.png

 

Labels
Top Solution Authors