You are viewing limited content. For full access, please sign in.

Question

Question

Delete entire rows of SQL Data with workflow

Workflow
Updated May 27, 2021
asked on May 27, 2021

I need to update a table in my SQL database with Workflow that will delete an entire row of data.

 

For instance, I have a workflow that will add a row of data, but when the workflow runs again, it is possible that the workflow will take a different branch and that row that was added will need to be deleted.  Can I do that?

0 0

Answer

SELECTED ANSWER
replied on May 27, 2021

Katy,

Yes, you can run a SQL DELETE query using the Custom Query workflow activity.  If you are not familiar with SQL query syntax do some research before you implement as you can easily delete the entire contents of a table if you don't have the WHERE clause set properly.

 

4 0
replied on May 27, 2021

Thank you.  I didn't realize the custom query could be used to update the database too.

 

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...