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

Question

Question

SQl Table Wipe

Workflow
Updated June 12, 2023
asked on June 9, 2023

I am using workflow to grab metadata from repository documents and populate an external SQL table. This works fine.

However, I would like to first clear/ wipe the table before I do the data push so that the table will have the metadata most current data. Can I do this with workflow?

0 0

Replies

replied on June 12, 2023

If you have an "Identity" column that needs to be reset with the wipe, then you will want to use the "Truncate Table" command instead of "Delete".

Difference between SQL Truncate and SQL Delete statements in SQL Server

2 0
replied on June 9, 2023

Yes, you need to use the Custom Query activity and you can add the appropriate SQL statement.

SQL DELETE Statement (w3schools.com)

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...