2021-06-15 20:53:34
Topic starter
Notifications
Clear all
Developer Network Q&A
4
Posts
4
Users
1
Reactions
2,327
Views
1
Hello,
Does anyone have a copy of the macro that deletes all the database schema contents?
Thanks!
Greg Merrill 2021-06-15 20:59:11
You want to empty the contents of tables, or actually drop the tables/indexes/procs/etc?
3 Answers
0
2021-06-15 21:01:14
Topic starter
I think emptying the contents should do it. My Bookstore project went sideways and I'm trying to recover.
0
2021-06-15 21:56:17
If you just want to delete the data in your database, but preserve the schema; then one way to do that is to run the following in SQL:
{call dtb.delete_data()}
0
2021-08-17 12:24:15
There is also the delete-data ant target that can be run from root:
ant delete-data
