Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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