How do I clear/truncate/delete BIBlend tables?

SteveK
New Contributor III

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

1 ACCEPTED SOLUTION

AndreaF
Contributor III

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.

View solution in original post

1 REPLY 1

AndreaF
Contributor III

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.