Skip to main content
Contributor
July 30, 2024
Solved

How do I clear/truncate/delete BIBlend tables?

  • July 30, 2024
  • 1 reply
  • 0 views

I have some BIBlend tables I have created during testing of a Workflow. that I want to delete/Truncate

Resetting the Scenario doesn't do it.

Do I need to do it programatically or via a Data Management job? When I try this it tells me that the SQL is not safe (I have tried with TRUNCATE TABLE and DELETE)

Thanks

Steve

Best answer by AndreaF

Hi, if it is a one-off you can write an extensibility rule to execute your SQL code. From there you are not restricted on the SQL commands you can run.

1 reply

AndreaFAnswer
Expert
August 2, 2024

Hi, if it is a one-off you can write an extensibility rule to execute your SQL code. From there you are not restricted on the SQL commands you can run.