Clearing out the database

Clearing out the database

  
I'm working on a site that contains a bootstrapped excel file with hundreds of rows and I want to just clear it out. I've deleted the bootstrapped file, but all the data still remains. Is there a way to just clear it all out at once so that I can start my table from a blank slate? Sorry if this is a simple question, I'm new to the Outsystems platform and I wasn't able to find a video about this. Thank you!
Solution
If you haven't done much with it and there aren't many fields you can create a new entity with a different name and create entity attributes with the same field names. Then delete the original entity.

If the previous option is not possible, here's what I do.

1) Create an Action that has an advanced query.  In that advanced query set the SQL to DELETE FROM {Entity} where Entity is the table name.  Note that the curly braces are required.
2) Create a web screen with one button.  Set the On Click to call the action you created.
3) View that web screen in a browser, click the button and the data is deleted.

Hope this helps,
Curt
Solution